Peter Kriha
Member²
I created the following two tables:
CREATE TABLE schema1.test(pk VARCHAR2(1) PRIMARY KEY);
INSERT INTO schema1.test VALUES ('1');
INSERT INTO schema1.test VALUES ('A');
and
CREATE TABLE schema2.test(pk VARCHAR2(1) PRIMARY KEY);
INSERT INTO schema2.test VALUES ('1');
Then I compared them using Compare Table Data with source table = schema1.test and target table = schema2.test.
The result was:
DELETE FROM schema2.TEST T WHERE PK = '1';
INSERT INTO schema2.TEST T (PK) VALUES ('A');
INSERT INTO schema2.TEST T (PK) VALUES ('1');
The row with PK = 1 is identical in the both tables, so why is it deleted and inserted again?
In reality I have the table with thousands rows and using Compare Table Data after adding one row to the source table generates the deletions and reinsertions of the whole target table!!!
Any workaround?
Peter
My environment:
PL/SQL Developer 7.0.3.1094 (MBCS)
Windows XP version 6,0 (build 2600) Service Pack 2
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0
Character size: 1 byte(s)
CREATE TABLE schema1.test(pk VARCHAR2(1) PRIMARY KEY);
INSERT INTO schema1.test VALUES ('1');
INSERT INTO schema1.test VALUES ('A');
and
CREATE TABLE schema2.test(pk VARCHAR2(1) PRIMARY KEY);
INSERT INTO schema2.test VALUES ('1');
Then I compared them using Compare Table Data with source table = schema1.test and target table = schema2.test.
The result was:
DELETE FROM schema2.TEST T WHERE PK = '1';
INSERT INTO schema2.TEST T (PK) VALUES ('A');
INSERT INTO schema2.TEST T (PK) VALUES ('1');
The row with PK = 1 is identical in the both tables, so why is it deleted and inserted again?
In reality I have the table with thousands rows and using Compare Table Data after adding one row to the source table generates the deletions and reinsertions of the whole target table!!!
Any workaround?
Peter
My environment:
PL/SQL Developer 7.0.3.1094 (MBCS)
Windows XP version 6,0 (build 2600) Service Pack 2
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0
Character size: 1 byte(s)