sequence help newbie!!

From: Robin Boscia <rboscia_at_att.com>
Date: Tue, 8 May 2001 17:08:08 -0700
Message-ID: <9da0u8$2k13@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 Tue May 08 2001 - 19:08:08 CDT