Re: EXPDP consistency error

From: gazzag <gareth_at_jamms.org>
Date: Thu, 1 May 2008 03:22:08 -0700 (PDT)
Message-ID: <fece564b-fc24-4dbf-96c9-53cd2874de65@b64g2000hsa.googlegroups.com>


On 30 Apr, 21:38, macdba321 <macdba..._at_gmail.com> wrote:
> 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!

What Oracle version and what was the syntax of the command you used? Received on Thu May 01 2008 - 05:22:08 CDT

Original text of this message