I am going to drop a primary key from one column and create a new
column to be used as primary key in an existing database.
The old column was a date column which someone earlier though was a
good candidate for a primary key which we all know it's not.

Now I want to add a new field, i.e. called ID, with a normal number
sequence as primary key.

I have dropped the primary key, created the new column, created the
new sequence and created a trigger to generate the primary key for new
inserts.

But I don't know how to generate/update the new ID column with
sequence numbers for the already existing records.

Any ideas?

/Kenneth

Hello Ken,

update <table> set pk_f = seq.nextval;

For big and active tables use PL/SQL block.

Regards,

Ron
DBA Infopower
http://www.dbainfopower.com
Standard disclaimer:
http://www.dbainfopower.com/dbaip_ad...isclaimer.html



"Ken1" <ken1 (AT) tjohoo (DOT) se> wrote