Database Administration (MOSC)

MOSC Banner

Child table FK constraints point to the interim table after online table reorganization

edited Sep 30, 2009 4:50AM in Database Administration (MOSC) 4 commentsAnswered ✓
 Hello,
I have a table X that has many child tables (A, B, C, D and E). After using dbms_redefinition to reorganize the table online, all the child tables FK constraints point to the interim table (X_ind). I had to drop and recreate all the FK to solve the problem and be able to drop the interim table. Here are the steps I followed, and everything went great until I wanted to drop the interim table:

1) Create table X_int with the appropiate definition and disabled constraints
2) dbms_redefinition.can_redef_table('user', 'X', DBMS_REDEFINITION.CONS_USE_PK);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center