Re: Full export and sequence behaviour in 8i

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Fri, 13 Mar 2009 22:09:53 +1100
Message-ID: <77a615a70903130409t191d0355j2e57bdb1ad775e94_at_mail.gmail.com>

I do not know when the sequences are exported, but if that is done before the tables (which is easily tested when you have a database to test on, which I do not have atm ) than I can imagine that some process inserted 4 records since the sequences were exported. Did you stop all application processes before the export?

Jack
2009/3/13 hrishy <hrishys_at_yahoo.co.uk>

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

-- 
Jack van Zanen

-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation

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

Received on Fri Mar 13 2009 - 06:09:53 CDT