Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Adding a Sequence to an existing table
In article <bf31b525.0107160416.7c6b5f3c_at_posting.google.com>,
paul_merlin_at_hotmail.com says...
> Hi,
>
> I need to add a sequence column to a table that currently has approx
> 3000 rows.
> I cannot change the name of the table as it is used by a number of
> different applications.
>
> Can anybody offer any advice.
>
> Thanks,
>
> Paul
>
Hi paul !
all you have to do:
create sequence sq_mytable start with 4000 nocache;
and modify your inserts to use sq_mytable.nextval !
Received on Mon Jul 16 2001 - 07:19:31 CDT