Oracle Corrupted Data Dictionary Objectsstored in sys.bootstrap$

Posted by PDSERVICE on Nov 14, 2015 In

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$

You are here