EXPDP consistency error

From: macdba321 <macdba321_at_gmail.com>
Date: Wed, 30 Apr 2008 13:38:46 -0700 (PDT)
Message-ID: <8a2c4216-1ec7-4791-9a90-1666c30cfeff@y38g2000hsy.googlegroups.com>

I exported a large schema using EXPDP today for the first time. When I IMPDP'd it into another server it imported fine. No errors. The application we use started giving a few errors, and on looking into it further, I've found that the objects did not export consistently. (ie., sequences's nextval values are lower than those already inserted into tables, such that when it goes to do a new insert, unique constraints are broken.)

Why would my expdp not have been consistent??

Thanks! Received on Wed Apr 30 2008 - 15:38:46 CDT

Original text of this message