咨询微信： dbservice1234 7 x 24 在线支持！

首页

下载 DBRECOVER

Oracle Corrupted Data Dictionary Objects stored in sys.bootstrap$

Oracle Corrupted Data Dictionary Objects stored in sys.bootstrap$

Posted by PDSERVICE on 11月 14, 2015 In

 

 

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

Parnassusdata Software Database Recovery Team

Service Hotline:  +86 13764045638 E-mail: service@parnassusdata.com

 

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$