Oracle Corrupted Data Dictionary Objectsstored in sys.bootstrap$

Posted by PDSERVICE on Nov 14, 2015 In

If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.

Data Dictionary Indexes in the bootstrap$ cannot be rebuilt/dropped

Data dictionary tables in bootstrap$ cannot be truncated/dropped

In general DDL operations cannot be executed on bootstrap$ objects.

Examples:

SQL> truncate table obj$;

truncate table obj$

ERROR at line 1:

ORA-00701: object necessary for warmstarting database cannot be altered

SQL> alter index i_obj1 rebuild;

alter index i_obj1 rebuild

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-00060: deadlock detected while waiting for resource

SQL> drop index i_obj2;

drop index i_obj2

ERROR at line 1:

ORA-00701: object necessary for warmstarting database cannot be altered

There are some objects not included in bootstrap$ that cannot be altered.

Error ORA-704 (object necessary for warmstarting database cannot be altered) is produced.

Note:279797.1 - "..Mark objects as non-bootstrapped“, contains bootstrapped objects that are not stored in table sys.bootstrap$