Home » SQL & PL/SQL » SQL & PL/SQL » Delete with commit scope (Oracle 10g, Win XP)
Delete with commit scope [message #346924] Wed, 10 September 2008 02:06 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
Hi all,

I have 1.5 million rows in my table and I need to delete these,
problem is temp space is very low , so I need to add commit scope of 1000, that is after every 1000 rows it should commit.
I am not getting any idea to do this,Please can antbody help!

from,
Freakabhi
Re: Delete with commit scope [message #346937 is a reply to message #346924] Wed, 10 September 2008 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As this has been asked and answered zillion times, I think you should have no difficulty to find the answer.
Of course, the correct answer is to enlarge the tablespace (undo/rollback not temp) to do it in a single transaction or to use one of the alternative way and NOT to use intermediate commits.

Regards
Michel
Re: Delete with commit scope [message #346945 is a reply to message #346924] Wed, 10 September 2008 02:51 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you TRUNCATE the table instead? As far as I understood, you want to empty the table completely (i.e. no records should remain).
Re: Delete with commit scope [message #346948 is a reply to message #346924] Wed, 10 September 2008 03:03 Go to previous message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
if you are not deleting all records of the table,
Look here
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2345591157689

Regards,
Dwarak
Previous Topic: what's the difference in terms of result
Next Topic: DBA_ ,USER_ views and procedure calls
Goto Forum:
  


Current Time: Fri Dec 09 19:47:20 CST 2016

Total time taken to generate the page: 0.09672 seconds