52
DBMS_REPAIR

DBMS_REPAIR contains data corruption repair procedures that enable you to detect and repair corrupt blocks in tables and indexes. You can address corruptions where possible and continue to use objects while you attempt to rebuild or repair them.

Note:

The DBMS_REPAIR package is intended for use by database administrators only. It is not intended for use by application developers.

See Also:

For detailed information about using the DBMS_REPAIR package, see Oracle9i Database Administrator's Guide.

This chapter discusses the following topics:

Security, Enumeration Types, and Exceptions

Security

The package is owned by SYS. Execution privilege is not granted to other users.

Enumeration Types

The DBMS_REPAIR package defines several enumerated constants that should be used for specifying parameter values. Enumerated constants must be prefixed with the package name. For example, DBMS_REPAIR.TABLE_OBJECT.

Table 52-1 lists the parameters and the enumerated constants.

Table 52-1 DBMS_REPAIR Enumeration Types

Parameter	Constant
object_type	TABLE_OBJECT, INDEX_OBJECT, CLUSTER_OBJECT
action	CREATE_ACTION, DROP_ACTION, PURGE_ACTION
table_type	REPAIR_TABLE, ORPHAN_TABLE
flags	SKIP_FLAG, NOSKIP_FLAG

Note:

The default table_name will be REPAIR_TABLE when table_type is REPAIR_TABLE, and will be ORPHAN_KEY_TABLE when table_type is ORPHAN_TABLE.

Exceptions

Table 52-2 DBMS_REPAIR Exceptions

Exception	Description	Action
942	Reported by `DBMS_REPAIR.ADMIN_TABLES` during a `DROP_ACTION` when the specified table doesn't exist.
955	Reported by `DBMS_REPAIR`. `CREATE_ACTION` when the specified table already exists.
24120	An invalid parameter was passed to the specified `DBMS_REPAIR` procedure.	Specify a valid parameter value or use the parameter's default.
24122	An incorrect block range was specified.	Specify correct values for the `BLOCK_START` and `BLOCK_END` parameters.
24123	An attempt was made to use the specified feature, but the feature is not yet implemented.	Do not attempt to use the feature.
24124	An invalid `ACTION` parameter was specified.	Specify `CREATE_ACTION`, `PURGE_ACTION` or `DROP_ACTION` for the `ACTION` parameter.
24125	An attempt was made to fix corrupt blocks on an object that has been dropped or truncated since `DBMS_REPAIR`.`CHECK_OBJECT` was run.	Use `DBMS_REPAIR`.`ADMIN_TABLES` to purge the repair table and run `DBMS_REPAIR`.`CHECK_OBJECT` to determine whether there are any corrupt blocks to be fixed.
24127	`TABLESPACE` parameter specified with an `ACTION` other than `CREATE_ACTION`.	Do not specify `TABLESPACE` when performing actions other than `CREATE_ACTION`.
24128	A partition name was specified for an object that is not partitioned.	Specify a partition name only if the object is partitioned.
24129	An attempt was made to pass a table name parameter without the specified prefix.	Pass a valid table name parameter.
24130	An attempt was made to specify a repair or orphan table that does not exist.	Specify a valid table name parameter.
24131	An attempt was made to specify a repair or orphan table that does not have a correct definition.	Specify a table name that refers to a properly created table.
24132	An attempt was made to specify a table name is greater than 30 characters long.	Specify a valid table name parameter.

52 DBMS_REPAIR