How to add a primary key column

I have a Table without a primary key and want to add a primary key. The problem is: how to update the existing columns with unique number values? I have the table with a column PK_Table and a sequence SEQ_Table. I thought the following statement would do it:

Update Table set PK_Table = (select SEQ_Table.NextVal from dual)

but this only results in ORA-02287: Sequence not allowed here. Any idea how to solve the problem, maybe with a cursor in PL/SQL?

Thanks,
Ralf Received on Wed Jul 02 2003 - 00:55:00 CDT