Home » SQL & PL/SQL » SQL & PL/SQL » Rollback segment problem during delete
Rollback segment problem during delete [message #211601] Fri, 29 December 2006 16:14 Go to next message
uicmxz
Messages: 48
Registered: July 2006
Member
I have to delete huge amount of data from five tables. I have rollback segment problem. I cannot store more then million records in the cursor. I selected service id and part no from main table to the PL/SQL records and passing parameters in where clause in dimensions tables.

Is there any other way I can do delete to avoid rollback problem?
Re: Rollback segment problem during delete [message #211602 is a reply to message #211601] Fri, 29 December 2006 16:19 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
TRUNCATE does not generate ROLLBACK
Re: Rollback segment problem during delete [message #211606 is a reply to message #211602] Fri, 29 December 2006 17:41 Go to previous messageGo to next message
uicmxz
Messages: 48
Registered: July 2006
Member
I cannot truncate table, because I have to delete only 2 million records over 52 mln.
Re: Rollback segment problem during delete [message #211607 is a reply to message #211601] Fri, 29 December 2006 17:56 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>I have rollback segment problem.
What error code/message is causing your problem(s)?
Re: Rollback segment problem during delete [message #211639 is a reply to message #211607] Sat, 30 December 2006 04:41 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can you split records to be deleted into smaller groups (for example, delete all where id between 0 - 100.000, then 100.001 - 200.000, etc.)?
Re: Rollback segment problem during delete [message #211663 is a reply to message #211639] Sat, 30 December 2006 20:10 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Here's some tips on high volume DML that might help

Ross Leishman
Previous Topic: check status of database via dblink?
Next Topic: Update table problem
Goto Forum:
  


Current Time: Fri Dec 02 14:19:20 CST 2016

Total time taken to generate the page: 0.10629 seconds