Re: sequence help newbie!!

If I understand right, your problem is that when you recreate your sequences they are reinitialised to 0. According to the manual, Oracle does not allow you to change the last number of a sequence. Wha you will have to do is recreate your sequences, setting the START WITH parameter to the last number on your old database.

Using SQL Navigator you can select all the sequences, perform an Extract DDL and then run the resulting script on your new DB.

"Robin Boscia" <rboscia_at_att.com> wrote in message news:9da0u8$2k13_at_kcweb01.netnews.att.com...
> I am a newbie
>
> We are doing an export and an import, upgrading from 7.3.4 to 8.1.6, also
> upgrading the O.S. and moving all the data to a new machine.
>
> We have everything up and working, except our sequences.
>
> We can see them and they look the same as on the old machine, however when
> we try to open a new ticket, it does not increment properly. It starts
 back
> at number 1.
>
> We have over 220 sequences and do not really want to drop and recreate all
> of them.
>
> Is there an easy way to get your sequences "working"? without going thru
> massive amounts of scripts?
> Can you put something in the export or the import file to increment
> properly?
>
>
> Also when you query your sequences, (we did not build the database or the
> tables), we can see the sequence and it's associated table, but how do you
> know what column that sequence would apply to (for incrementation )?
>
>
> Thanks
> Robin
>
>
Received on Wed May 09 2001 - 02:49:28 CDT