Home » RDBMS Server » Performance Tuning » Perfomance in Delete and Insert
Perfomance in Delete and Insert [message #279749] Sat, 10 November 2007 02:10 Go to next message
mohseni
Messages: 3
Registered: November 2007
Location: india
Junior Member

Hi,
I want to delete many rows from my primary table(on db1) and insert them into another table in another database(db2).

How can i delete records from primary database(db1) and insert them into second database(db2) by over 500 record per second performance.

Thanks.

[Updated on: Sat, 10 November 2007 02:21]

Report message to a moderator

Re: Perfomance in Delete and Insert [message #279781 is a reply to message #279749] Sat, 10 November 2007 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you talking about real databases or schemas?
Have a look at "insert select" with append and, possibly, parallel options.

Regards
Michel

[Updated on: Sat, 10 November 2007 03:54]

Report message to a moderator

Re: Perfomance in Delete and Insert [message #279795 is a reply to message #279749] Sat, 10 November 2007 06:30 Go to previous messageGo to next message
mohseni
Messages: 3
Registered: November 2007
Location: india
Junior Member

I speak about schemas.

I hava primary schema that have a table that my system insert it's data into it.

My need is a mechanism for deleting out of date records from mentioned table to another table in another schema that is in second databas system.


Please Help Me if you have any idea

[Updated on: Sat, 10 November 2007 06:32]

Report message to a moderator

Re: Perfomance in Delete and Insert [message #279804 is a reply to message #279795] Sat, 10 November 2007 09:23 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
insert /*+ append */ into db1.tab select * from db2.tab;
truncate table db2.tab;

Regards
Michel
Previous Topic: Process Threads
Next Topic: truncate
Goto Forum:
  


Current Time: Wed Dec 07 10:32:38 CST 2016

Total time taken to generate the page: 0.11293 seconds