Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence reset by import
This happened to me once. I couldn't figure out. So I started over and it was OK. That was a mistery. I'm using Oracle 8.1.5 for Sun Sparc.
Yong Huang
yhuang_at_indigopool.com
<ashish25_at_my-deja.com> wrote in message news:8tui89$a6u$1_at_nnrp1.deja.com...
> 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.
Received on Fri Nov 03 2000 - 16:14:58 CST