| Ratnaker |
Posted: May 02, 2007 05:35:11 AM |
Total Post: 136
Joined: Apr, 2007
|
We have 100 million data in one table i want to delete 50 mollion record from the table. How we can delete? What will be the effect in database?
Ratnaker |
|
|
 sm_ahmeds |
| Posted: May 02, 2007 08:38:51 AM |  |
|
Total Post: 53
Joined: Apr, 2007
|
Hi Retnaker....u can use delete from table where rownum<5000000
|
|
|
|
|
| Ratnaker |
| Posted: May 03, 2007 01:31:19 AM | |
|
Total Post: 136
Joined: Apr, 2007
|
Hi ahemad,
It will delete from table but it is taking log time.some times its trgoughing error.
Ratnaker
|
|
|
|
|
| poonam |
| Posted: May 08, 2007 09:11:29 AM | |
|
Total Post: 7
Joined: May, 2007
|
hi,
as its large no. of records you want to delete,
why dont u try..........
TRUNCATE table...
if u want to delete all data from table.its much faster and generate less undo.its useful if u dont want to use ROLLBACK......
regards...........
|
|
|
|
|
| Bubun |
| Posted: Jul 10, 2007 02:36:06 AM | |
|
Total Post: 4
Joined: Jul, 2007
|
Hi,
Its a part of my job also to delete millions of records from a table and I delete from offshore. Try below method which will fulfill ur need.
Make a Pl/sql block which will delete atleast 50000 records at a time and after delete script commit the record , so that it won't throw any error
during deletion. If you didn't get my point , inform me , so that I will
mention one example as template.
Subhra
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
