export: problem with tw inserts on dbms_wm.export
Hello,
there is following workflow
CREATE TABLE test_sv(
ID NUMBER,
text VARCHAR2(100));
ALTER TABLE test_sv ADD CONSTRAINT test_sv_pk PRIMARY KEY (ID);
and made it version enabled.
i set a valid time and inserted a record: INSERT INTO test_sv (ID,text) VALUES (1,'feb 2006');
i set a valid time which didn't overlap the first one
and inserted a new one: INSERT INTO test_sv (ID,text) VALUES (1,'mrz 2006');
with the dbms_wm.export i wanted to export two records.
following result raised:
ORA-00001: unique constraint (EXPORT_VIETS.SYS_C00115680) violated
ORA-06512: at "SYS.LT", line 12625
ORA-06512: at "SYS.LT", line 12599
ORA-06512: at line 2
An experiment with the export_scpoe parameter raised an error.
Oracle Version 10.1.0.4
What is wrong on it. Is there a workaround?
Thanks and Greetings
Silke Viet