Re: newbie ? on sequence #'s

hi

if your sequence start at 1 and you want to put it at 20 you can use this command

alter sequence my_seq increment by 19;
select my_seq.nextval from dual;
alter sequence my_seq increment by 1;

hth
Chris

Robin Boscia <rwboscia1_at_home.com> wrote in message news:<B81371A7.7347%rwboscia1_at_home.com>...
> 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!
> robin
Received on Wed Nov 14 2001 - 01:11:52 CET