Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
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.
See Also:
For detailed information about using the |
This chapter discusses the following topics:
The package is owned by SYS
. Execution privilege is not granted to other users.
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 47-1 lists the parameters and the enumerated constants.
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 |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|