ORA-00701: object necessary for warmstarting database cannot be altered 百度到eygle说的高水位上有些索引是可以通过rebuild来改变其位置的,但是在正常模式下,Oracle不允许rebuild这些索引; 两种解决方案1.通过migrate模式。 2.通过一个内部事件 地址在这里http://www.eygle.com/archives/2007/02/ora_00701_warmsta...
ORA-00701: object necessary for warmstarting database cannot be altered有两种方式可以使得这些对象允许被重建: 1.通过migrate模式SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup migrate; ORACLE instance started. Total System Global Area 139531744 byt...
ERROR at line 1: ORA-00701: object necessary for warmstarting database cannot be altered SQL> ! oerr ora 38003 38003, 00000, "CBO Disable column stats for the dictionary objects in recursive SQL" // *Cause: // *Action: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 1. 可以通过38003 event...
has anybody an idea how to solve the error ORA-00701: object necessary for warmstarting database cannot be altered??? SQL> ALTER INDEX sys.I_OBJ2 storage (maxextents 600); ALTER INDEX sys.I_OBJ2 storage (maxextents 600) * ERROR at line 1: ORA-00701: object necessary for warmstarting ...
ORA-00701: object necessary for warmstarting database cannot be altered SQL> ! oerr ora 38003 38003, 00000, "CBO Disable column stats for the dictionary objects in recursive SQL" // *Cause: // *Action: 1. 可以通过38003 event禁用递归SQL中队数据字典对象字段信息的核实,但是注意设置该38003 event...
ORA-00701: object necessary for warmstarting database cannot be altered SQL> SELECT SQL_TEXT FROM BOOTSTRAP$ WHERE SQL_TEXT LIKE '%obj%'; SQL_TEXT --- CREATE UNIQUE INDEX I_OBJ1 ON OBJ$(OBJ#,OWNER#,TYPE#) PCTFREE 10 INITRANS 2 MAXT RANS 255 STORAGE ( INITIAL ...
本文链接地址:How to recreate Bootstrap Index(I_OBJ1,I_USER1,I_FILE#_BLOCK#) to fix ORA-00701 ? 在上一篇数据恢复文章中,我提到了bootstrap 核心数据数据字典表的对象index出现异常后,难以修复。实际上,仅仅是数据不一致(或类似的情况)导致的index异常,其实有其他的方式进行重建。实际上Oracle 11gR2版本...
has anybody an idea how to solve the error ORA-00701: object necessary for warmstarting database cannot be altered??? SQL> ALTER INDEX sys.I_OBJ2 storage (maxextents 600); ALTER INDEX sys.I_OBJ2 storage (maxextents 600) * ERROR at line 1: ORA...