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

Q.  If START_REDEF_TABLE fails for any reason, you must call ABORT_REDEF_TABLE, otherwise subsequent attempts to redefine the table will fail.
- Published on 04 Aug 15

a. True
b. False

ANSWER: True
 

    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


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)