Home » Server Options » Replication » delete bulk rows from table
delete bulk rows from table [message #75311] Tue, 21 January 2003 00:25 Go to next message
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 Go to previous messageGo to next message
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!
Re: delete bulk rows from table [message #75557 is a reply to message #75311] Mon, 11 October 2004 07:25 Go to previous message
Courtney Romney
Messages: 1
Registered: October 2004
Junior Member
how do i delete my bulk folder forever
Previous Topic: dbms_refresh.refresh does not update secondary DB
Next Topic: 3 Master sites - Group Problem ?!
Goto Forum:
  


Current Time: Sat Jan 25 17:14:02 CST 2020