Re: Full export and sequence behaviour in 8i
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: Jack van Zanen <jack@xxxxxxxxxxxx>
- Date: Fri, 13 Mar 2009 11:32:19 +0000 (GMT)
Hi Jack
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
regards
Hrishy
--- On Fri, 13/3/09, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:
> From: Jack van Zanen <jack@xxxxxxxxxxxx>
> Subject: Re: Full export and sequence behaviour in 8i
> To: hrishys@xxxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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
> application
> processes before the export?
>
> Jack
> 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
> >
> >
> >
> > --
> > //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
