dbms_repair.orphan_table : DBMS_REPAIR « System Packages « Oracle PL / SQL

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

dbms_repair.orphan_table

 

SQL>
SQL>
SQL> BEGIN
  2   DBMS_REPAIR.ADMIN_TABLES (
  3   TABLE_NAME => 'ORPHAN_KEY_TABLE',
  4   TABLE_TYPE => dbms_repair.orphan_table,
  5   ACTION => dbms_repair.create_action,
  6   TABLESPACE => 'USERS');
  7  END;
  8  /



SQL>
SQL>
SQL>

 

Related examples in the same category