Re: Full export and sequence behaviour in 8i

  • From: Jack van Zanen <jack@xxxxxxxxxxxx>
  • To: hrishys@xxxxxxxxxxx
  • Date: Fri, 13 Mar 2009 22:09:53 +1100

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?

2009/3/13 hrishy <hrishys@xxxxxxxxxxx>

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

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

Other related posts: