we have a production machine & a test machine with the data being used for a
ticketing system.
we keep some data on the test machine for our use, so every so often, i do
an export & an import of that data.
once i move the data to the new machine, i run scripts to enable
constraints, check invalid packages, etc.
i however am having a ??? on my sequences.
once the data is on the new machine, if i input a new ticket, via my ticket
application gui, it does not sequence correctly. the tickets start back at
1. is there an easy way to start at the next #? this affects quite a few
tables.....
thanks!