Re: Full export and sequence behaviour in 8i
Date: Fri, 13 Mar 2009 08:15:09 -0500
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.
"Next to doing a good job yourself,
the greatest joy is in having someone else do a first-class job under your direction."
- William Feather
On Fri, Mar 13, 2009 at 7:51 AM, Hostetter, Jay M < JHostetter_at_decommunications.com> wrote:
> 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.
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of hrishy
> Sent: Friday, March 13, 2009 7:32 AM
> To: Jack van Zanen
> Cc: oracle-l_at_freelists.org
> 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
> 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.