delete bulk rows from table [message #75311] |
Tue, 21 January 2003 00:25 |
Amita Kapadia
Messages: 8 Registered: January 2002
|
Junior Member |
|
|
Dear All,
I would like to move data from one table to another table in different tablespace. Presently I am inserting data into new table and delete rows from old table. I would like to know whether select for update in procedure is faster or select and delete on primary key is faster.
Thanks
|
|
|
Re: delete bulk rows from table [message #75484 is a reply to message #75311] |
Fri, 12 March 2004 06:12 |
Aldred Frost
Messages: 1 Registered: March 2004
|
Junior Member |
|
|
If the new table is identical to the old table there is no need to copy the rows individually.
To move a table to a new tablespace, you can use the following
ALTER TABLE {TABLE_NAME} MOVE
TABLESPACE {NEW_TABLESPACE}
;
You can also use this to change storage attributes for a table at the same time.
Depending on the number of rows in the source table, it can take a while but it does it all online without interrupting user access to the data!
|
|
|
|