Using the DBMS_REPAIR.CHECK_OBJECT Procedure : DBMS_REPAIR « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. DBMS_REPAIR

Using the DBMS_REPAIR.CHECK_OBJECT Procedure

 
SQL>
SQL> DECLARE num_corrupt INTEGER;
  2  BEGIN
  3  num_corrupt := 0;
  4  DBMS_REPAIR.CHECK_OBJECT(
  5  schema_name => 'HR',
  6  object_name => 'EMP',
  7  repair_table_name => 'REPAIR_TABLE',
  8  corrupt_count => num_corrupt);
  9  END
 10  /
END








Related examples in the same category

1.Using the DBMS_REPAIR.FIX_CORRUPT_BLOCKS Procedure
2.dbms_repair.orphan_table
3.dbms_repair.create_action