RE: Full export and sequence behaviour in 8i

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

regards
Hrishy

**DISCLAIMER
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.

--
http://www.freelists.org/webpage/oracle-l