Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence reset by import
Hi David,
I am using
Oracle8i Enterprise Edition Release 8.1.6.1.0 on
LINUX 2.2.14-5.0.14c
Thanks,
Ashish
In article <8tujil$bj8$1_at_nnrp1.deja.com>,
David Fitzjarrell <oratune_at_aol.com> wrote:
> In our last gripping episode ashish25_at_my-deja.com wrote:
> > Hi,
> > Does import resets a sequence.
> > I did an export for a user and then did an import with rows=n
and
> > indexfile=xxx.sql to generate the scripts.Is there any way that it
reset
> > a sequenece owned by user.
> > I was using this sequence to build a primary key.After I did
the
> > exercise of export and import when the next time the process was run
it
> > had higher value in tables primary key then sequence.
> > I did a test with another user but it did non reset the
sequenece.??
> > Anybody encountered a problem like this.
> > Thanks and regards,
> > Ashish
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Please provide the version of Oracle you are using -- assistance will
> be easier to provide knowing that.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 03 2000 - 09:03:26 CST