Child table FK constraints point to the interim table after online table reorganization
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);
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);
0