SQLServer is connected with Microsoft MSSQL Server JDBC Driver.
Oracle is connected with Oracle Thin Driver
Create a table on SQLServer:
CREATE TABLE TESTTABLE
(
testcolumn1 varchar(10) PRIMARY KEY,
testcolumn2 varchar(80)
);
INSERT INTO TESTTABLE (testcolumn1,testcolumn2) VALUES ('TST05','Test 05');
INSERT INTO TESTTABLE (testcolumn1,testcolumn2) VALUES ('TST06','Test 06');
INSERT INTO TESTTABLE (testcolumn1,testcolumn2) VALUES ('TST08','Test 08');
INSERT INTO TESTTABLE (testcolumn1,testcolumn2) VALUES ('TST09','Test 09');
INSERT INTO TESTTABLE (testcolumn1,testcolumn2) VALUES ('TST10','Test 10');
Try to copy the table to Oracle - the error message is
ORA-01408: such column list already indexed.
Doing the same the other way round (copy from Oracle to SQLServer) works.
Error message popup