|
- select * from v$database_block_corruption;
- select * from repair_table;
- select * from orphan_key_table;
- select okt.index_name, dump(key) from orphan_key_table okt;
- 195 3 95 77
- 10000*(3-1) +100*(95-1) +(77-1) =29476
- begin
- dbms_repair.skip_corrupt_blocks(schema_name => 'HR',
- object_name => 'TLOGICAL');
- end;
- drop index hr.ilogical_a;
- drop index hr.ilogical_b;
复制代码
127.0.0.1 webiq-cdn.appspot.com webiq-cdn
127.0.0.1 fonts.googleapis.com fonts
127.0.0.1 ajax.googleapis.com ajax
127.0.0.1 apis.google.com apis
/u01/app/oraInventory/ContentsXML/inventory.xml- <?xml version="1.0" standalone="yes" ?>
- <!-- Copyright (c) 1999, 2009, Oracle. All rights reserved. -->
- <!-- Do not modify the contents of this file by hand. -->
- <INVENTORY>
- <VERSION_INFO>
- <SAVED_WITH>11.2.0.1.0</SAVED_WITH>
- <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
- </VERSION_INFO>
- <HOME_LIST>
- <HOME NAME="Ora11g_gridinfrahome1" LOC="/u01/app/oracle/product/11.2.0/grid" TYPE="O" IDX="1"/>
- <HOME NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="2"/>
- </HOME_LIST>
- </INVENTORY>
复制代码
|
|