Home » SQL & PL/SQL » SQL & PL/SQL » How to do Implied Commit
How to do Implied Commit [message #301234] Tue, 19 February 2008 14:43 Go to next message
Messages: 11
Registered: May 2007
Junior Member

I have to delete millions of rows from a table while keeping millions of others. I was wondering is there a way of writing a delete command that will commit the delete after every 50,000 rows as opposed to waiting for me to type commit when the delete is done.

DELETE from test
WHERE param < 3;
Re: How to do Implied Commit [message #301235 is a reply to message #301234] Tue, 19 February 2008 14:45 Go to previous messageGo to next message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, a statement is a whole, it is atomic, it either completly succeeds or completly fails.

Re: How to do Implied Commit [message #301246 is a reply to message #301234] Tue, 19 February 2008 16:33 Go to previous message
Messages: 508
Registered: March 2005
Senior Member
As you might guess, this is not something that nobody has ever come across before. Deleting millions of rows is rarely a good idea. See the link below for a intro on why.


But if you still think delete is a good idea, you might want to revisit the question of why you need intermittent commit. Unless you have a really, really good reason why you need them ("Because somebody said I should", is not a good reason), just don't do them.
Previous Topic: Invalid number error when trying to retrieve numeric data from varchar2 columns.
Next Topic: How to achieve Global Temporary Functionality by using the Table
Goto Forum:

Current Time: Sun Jul 23 09:58:35 CDT 2017

Total time taken to generate the page: 0.09561 seconds