| BUlk Delete [message #425408] |
Fri, 09 October 2009 01:36  |
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
|
Senior Member |
|
|
We have 50 million data in one table i want to delete 20 mollion record from the table. How we can delete? What will be the effect in database?
plese give me one example with complete code.
|
|
|
|
|
|
| Re: BUlk Delete [message #425413 is a reply to message #425408] |
Fri, 09 October 2009 01:50  |
 |
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Save the rows you want to keep in a table, truncate the original one, and reinsert the saved rows.
Use CTAS, direct (append) insert and if possible parallelism.
This will be very fast and requires very fex redo logs.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
