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>
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