Re: Sequence reset by import

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.