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>
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-lReceived on Fri Mar 13 2009 - 04:46:49 CDT