adding a foreign key constraint to a versioned table?
Can you add a foreign key constraint to a versioned table?
When I try, I do the beginddl, alter the _LTS table, and then when I try to do the commitddl, I get an unsupported constraint error. For example:
SQL> exec dbms_wm.beginddl('table_name');
SQL> alter table table_name_LTS add constraint FK_CONS foreign key (xyz) references other_table(xyz);
SQL> exec dbms_wm.commitddl('table_name');
BEGIN dbms_wm.commitddl('table_name'); END;
*
ERROR at line 1:
ORA-20200: unsupported constraint USER.FK_CONS detected
ORA-06512: at "WMSYS.LT", line 12225
ORA-06512: at line 1
Can this be done without un-versioning the table?
Thanks,
Bill Auslander