update sequence values [message #10019] |
Mon, 22 December 2003 11:29 |
MM
Messages: 27 Registered: July 2002
|
Junior Member |
|
|
I have a table which has a line_no field and this field is being incremented by a numeric value. It has about 2 million rows. Further any inserts into this table i want to use a Oracle generated sequence for the line_no field. I have created a sequence and using it against the new entries.
I need to update the old values of line_no to use the sequence number. I can do this by issuing an update statement based on key values. As update may take longer for 2 million rows, IS there any other options i can achieve this?
Any inputs appreciated
Thanks,
MM
|
|
|
|
Re: update sequence values [message #10028 is a reply to message #10020] |
Tue, 23 December 2003 06:41 |
MM
Messages: 27 Registered: July 2002
|
Junior Member |
|
|
By creating the sequence with a higher cache as 100000 how do i update the previous values in line_no feild which was not part of the sequence number generation to use the current sequence pattern?
Can you explain me in detail?
Thanks
MM
|
|
|
|