Re: EXPDP consistency error

From: JACKY <zhpsam_at_gmail.com>
Date: Mon, 5 May 2008 05:48:59 -0700 (PDT)
Message-ID: <73582027-701f-4366-8312-778edcdb1b50@d19g2000prm.googlegroups.com>


On 5月1日, 下午6时22分, gazzag <gar..._at_jamms.org> wrote:
> 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?

might,you must stop your application and then use expdp utility export you data! Received on Mon May 05 2008 - 07:48:59 CDT

Original text of this message