Re: Full export and sequence behaviour in 8i
Date: Fri, 13 Mar 2009 11:32:19 +0000 (GMT)
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
- On Fri, 13/3/09, Jack van Zanen <jack_at_vanzanen.com> wrote:
> From: Jack van Zanen <jack_at_vanzanen.com>
> Subject: Re: Full export and sequence behaviour in 8i
> To: hrishys_at_yahoo.co.uk
> Cc: oracle-l_at_freelists.org
> Date: Friday, 13 March, 2009, 11:09 AM
> 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
> processes before the export?
> 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