Re: duplicate after restore

Posted by ErmanArslansOracleBlog on Jan 30, 2023; 7:00am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/duplicate-after-restore-tp11508p11535.html

It depends the case. and I guess I still couldn't understand the issue clearly.
Are those columns defined AS IDENTITY? What is the definition of a problematic table? Do you have data in the target table (in those ID columns) before your import?
These questions should be answered..
If your case is similar to the one given in that blog, having START WITH LIMIT VALUE on target may work for you. (I guess you don't want to touch the source) But is that your issue? Do you import data into a table that already has some row in it? But note that, this modifies the values of ID columns.. Just note it.