I have a question because I want to transfer data from an SQL Server system to Oracle. The transfer includes about 15 tables. I want just to skip or replace double primary key values in the destination database. Otherwise I get a key/constraint violation and my procedure is not executed and no rows are inserted. Assume I have about 1.000.000 rows per day I want to transfer and need an effective way to do the task.
Appreciate any suggestions
Thanks so far!