Full export and sequence behaviour in 8i

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 13 Mar 2009 09:46:49 +0000 (GMT)
Message-ID: <754246.99337.qm_at_web23704.mail.ird.yahoo.com>


Hi

We have exported 8i database and imported into 10g using full=y. After this i notice useres complaining about unique constraint violation as the sequence numbers have a value less then the primary key in some of the tables.Example the seq number is 38 and the table pk has a value of 42

Is it a expected behaviour in export import.

regards
Hrishy       

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 13 2009 - 04:46:49 CDT

Original text of this message