Oracle in a Nutshell

Calls

PROCEDURE DBMS_REPAIR.ADMIN_TABLES (table_name IN VARCHAR2, table_type IN BINARY_INTEGER, action IN BINARY_INTEGER, tablespace IN VARCHAR2 DEFAULT NULL);

Repairs administrative tables (ORPHAN_TABLE or REPAIR_TABLE in table_type) for table_name. action is either CREATE_ACTION to create the table, PURGE_ACTION to delete rows from the table for nonexistent objects, or DROP_ACTION to drop the table. tablespace is the tablespace used when creating a table.

PROCEDURE DBMS_REPAIR.CHECK_OBJECT (schema_name IN VARCHAR2, object_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL object_type IN BINARY_INTEGER DEFAULT TABLE_OBJECT, repair_table_name IN VARCHAR2 DEFAULT 'REPAIR_TABLE', flags IN BINARY_OBJECT DEFAULT NULL, relative_fno IN BINARY_INTEGER DEFAULT NULL, block_start IN BINARY_INTEGER DEFAULT NULL, block_end IN BINARY_INTEGER DEFAULT NULL, corrupt_count OUT BINARY_INTEGER);

Checks schema_name.object_name, in partition_name (if relevant) of object_type (TABLE_TYPE or INDEX_TYPE). Adds rows to repair_table, which must exist in the SYS schema. relative_fno is the relative file number and block_start and block_end specify the block range. repair_table_name is the name of the repair table that will be populated. flags is reserved for future use. Returns corrupt_count of number of corruptions reported.

PROCEDURE DBMS_REPAIR.DUMP_ORPHAN_KEYS (schema_name IN VARCHAR2, object_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL object_type IN BINARY_INTEGER DEFAULT INDEX_OBJECT, ...