December 2002
Intermediate to advanced
928 pages
85h 29m
English
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, ...