Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11G datapump and sequences issue

user2522172Jun 24 2010 — edited Mar 31 2012

Hi,

I did a schema (datapump: expdp) dump on a 11G database and imported it with impdp on another instance. I removed all schema objects before importing on the destination instance. The import went without problems. But after a while we got ora-0001 primary key violations. The reason were some sequences which had a value lower than the value in some tables. It seems Oracle dump first the sequences an afterwards the oracle data. They are out of sync. I thought datapump made consistent dumps. Is this a known issue?

regards,

Ivan

This post has been answered by Hemant K Chitale on Jun 25 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2012

Added on Jun 24 2010

#database-key-features, #export-import-sql-loader-external-tables

7 comments

24,013 views