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






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

Using the DBMS_REPAIR.FIX_CORRUPT_BLOCKS Procedure

 
SQL>
SQL> DECLARE num_fix INTEGER;
  2  BEGIN
  3  num_fix := 0;
  4  DBMS_REPAIR.FIX_CORRUPT_BLOCKS(
  5  schema_name => 'HR',
  6  object_name => 'EMP',
  7  object_type => dbms_repair.table_object,
  8  repair_table_name => 'REPAIR_TABLE',
  9  fix_count => num_fix);
 10  END;
 11  /








Related examples in the same category

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