Re: Full export and sequence behaviour in 8i

From: Bradd Piontek <>
Date: Fri, 13 Mar 2009 08:15:09 -0500
Message-ID: <>

Unfortunately, CONSISTENT=Y has no bearing on sequences. Sequences are exported prior to the tables. If you are exporting even a mildly busy database, your sequences will be out of whack. This is true with exp and expdp (at least through 10gR2).

If your database is coded to 'auto-increment' sequences based on a table trigger, I have a fairly non-trivial PL/SQL package I could share that goes through all the tables in the schema to find the max PK and recreates the sequences if they need to be recreated.

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
  • William Feather

On Fri, Mar 13, 2009 at 7:51 AM, Hostetter, Jay M <> wrote:

> Hrishy,
> The CONSISTENT=Y parameter (during the export) might help to resolve
> this issue. You would have to ask for a new export from the source
> system. Check the documentation for it's use and restrictions.
> Jay
> -----Original Message-----
> From:
> [] On Behalf Of hrishy
> Sent: Friday, March 13, 2009 7:32 AM
> To: Jack van Zanen
> Cc:
> Subject: Re: Full export and sequence behaviour in 8i
> Hi Jack
> Thanks for a response.
> No i am the receipent of the export and have no way to find out how the
> export was done.
> I was the one who imported it and getting the unique constraint
> violation errors but your explanation seems to be logical and the
> sequences seem to be exported before tables atleast in 8i looking at the
> export logfile
> regards
> Hrishy
> This e-mail message and any files transmitted with it are intended for the
> use of the individual or entity to which they are addressed and may contain
> information that is privileged, proprietary and confidential. If you are not
> the intended recipient, you may not use, copy or disclose to anyone the
> message or any information contained in the message. If you have received
> this communication in error, please notify the sender and delete this e-mail
> message. The contents do not represent the opinion of D&E except to the
> extent that it relates to their official business.
> --

Received on Fri Mar 13 2009 - 08:15:09 CDT

Original text of this message