STARTREDEFTABLE fails for any reason, you must call ABORTREDEFTABLE - Oracle Tables

Discussion

• Nirja Shah   -Posted on 01 Oct 15
  - Start the redefinition process by calling START_REDEF_TABLE, providing the following:
  1. The schema and table name of the table to be redefined
  
  2. The interim table name
  
  3. A column mapping string that maps the columns of table to be redefined to the columns of the interim table
  
  4. The redefinition method
  - Package constants are provided for specifying the redefinition method.
  - DBMS_REDEFINITION.CONS_USE_PK is used to indicate that the redefinition should be done using primary keys or pseudo-primary keys.
  - DBMS_REDEFINITION.CONS_USE_ROWID is use to indicate that the redefinition should be done using rowids.
  - If this argument is omitted, the default method of redefinition (CONS_USE_PK) is assumed.
  
  5. Optionally, the columns to be used in ordering rows
  
  6. If redefining only a single partition of a partitioned table, the partition name
  
  - Because this process involves copying data, it may take a while.
  
  - The table being redefined remains available for queries and DML during the entire process.
  
  - If START_REDEF_TABLE fails for any reason, you must call ABORT_REDEF_TABLE, otherwise subsequent attempts to redefine the table will fail.

➨ Post your comment / Share knowledge