Hi:

i have a table which already has data. now i want to add a new column with data. teh column acts as a serial no. how do i update the current records with the new serial no? i did teh bellow:

DECLARE x NUMBER := 1;
BEGIN
WHILE x < 601 LOOP
UPDATE TABLE1
SET SERIAL_NO =x;
x := x+1;
END LOOP;
END;

The following error has occurred:

ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1'

ORA-06512: at line 4

Kindly help.