Re: duplicate after restore

Posted by ErmanArslansOracleBlog on Jan 29, 2023; 8:22am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/duplicate-after-restore-tp11508p11526.html

3 questions and  some requests:

1)So the imported data is okay. No problem with that. Tere are no duplicate rows, but the values of some ID columns (which are populated by the sequences) are the same as the source.

-send me an example just 2 records. (mask the sensitive info)

2)Did you interrupt the impdp (once or twice)? I mean did you get any error during your first import session for instance?

3)What does the impdp log says? Anything weird about the affected tables or sequences there?

4)When you check the expdp dmp file and search for a problematic sequence, what do you see for the start values? (I mean the creation script itself)

Please update this thread with your findings.