Email: service@parnassusdata.com 7 x 24 online support!

    You are here

Oracle Corrupted Data Dictionary Objects stored in sys.bootstrap$

Oracle Corrupted Data Dictionary Objects stored in sys.bootstrap$

 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$