Database Administration (MOSC)

MOSC Banner

DBMS_REPAIR package procedures - 10g

edited Jun 18, 2009 2:38AM in Database Administration (MOSC) 1 commentAnswered
 Hi,

 I am trying to fix a corrupt data block in the SYSAUX tablespace. The segment types associated with this corruption are INDEX (I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) andTABLE (WRH$_SQL_BIND_METADATA). I ran the DBMS_REPAIR  package check_objects and dump_orphan_keys for the table and index respectively. Fot the check_objects the repair_table is populated with basic information-stuff that I get anyway using DBverify. I was mainly interested in the corrupt description column which did not get populated. How can I get the info.

For the dump_orphan_keys my script gives me an error as follows:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center