ORA-20104: cannot version disable this table
ORA-06512: at "SYS.LT", line 9152
ORA-06512: at line 3
the following error will occur if the TESTP table is a parent table and all the child table that refers TESTP is not versiondisabled .
An Example
create table TEST (ee number(10),fg varchar2(100)) ;
ALTER TABLE TEST ADD CONSTRAINT TEST_PK PRIMARY KEY (EE);
create table TESTP (ff number(10),ee number(10) ,constraint fk_fg foreign key(ee) references TEST(ee) );
ALTER TABLE TESTP ADD CONSTRAINT TESTp_PK PRIMARY KEY (ff);
execute dbms_wm.enableversioning('TEST');
execute dbms_wm.enableversioning('TESTP');
execute dbms_wm.disableversioning('TESTP'); This will result an error ( ORA-20104: cannot version disable this table )
to avoid this first you should disableversion child table TEST and then parent table TESTP
execute dbms_wm.disableversioning('TEST');
execute dbms_wm.disableversioning('TESTP');
ORA-06512: at "SYS.LT", line 9152
ORA-06512: at line 3
the following error will occur if the TESTP table is a parent table and all the child table that refers TESTP is not versiondisabled .
An Example
create table TEST (ee number(10),fg varchar2(100)) ;
ALTER TABLE TEST ADD CONSTRAINT TEST_PK PRIMARY KEY (EE);
create table TESTP (ff number(10),ee number(10) ,constraint fk_fg foreign key(ee) references TEST(ee) );
ALTER TABLE TESTP ADD CONSTRAINT TESTp_PK PRIMARY KEY (ff);
execute dbms_wm.enableversioning('TEST');
execute dbms_wm.enableversioning('TESTP');
execute dbms_wm.disableversioning('TESTP'); This will result an error ( ORA-20104: cannot version disable this table )
to avoid this first you should disableversion child table TEST and then parent table TESTP
execute dbms_wm.disableversioning('TEST');
execute dbms_wm.disableversioning('TESTP');
No comments:
Post a Comment