Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence reset by import

Re: Sequence reset by import

From: <ashish25_at_my-deja.com>
Date: Fri, 03 Nov 2000 15:03:26 GMT
Message-ID: <8tuk3n$c3t$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US