Home » SQL & PL/SQL » SQL & PL/SQL » delete without logging
delete without logging [message #251145] Thu, 12 July 2007 08:57 Go to next message
Messages: 13
Registered: March 2007
Junior Member

i have do delete a lot of tuples. I know it will take a lot of time, therefore i want turn off commit. I know it from other databases that is possible and without logging the delete will going much more faster, but i can not find the command. I don't want change global parameters, i want only turn off it in my session.
Re: delete without logging [message #251147 is a reply to message #251145] Thu, 12 July 2007 09:01 Go to previous messageGo to next message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In Oracle, you can't.
If you want to delete all rows, have a look at TRUNCATE.

Re: delete without logging [message #251167 is a reply to message #251145] Thu, 12 July 2007 10:15 Go to previous message
Bill B
Messages: 1662
Registered: December 2004
Senior Member
There are tricks to do fast deletes. How many rows are in the table and how many of those do you want to delete?
Previous Topic: selecting user defined records into ref cursor
Next Topic: counting number of records (merged)
Goto Forum:

Current Time: Sat Aug 19 08:10:57 CDT 2017

Total time taken to generate the page: 0.04671 seconds