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
ddaannyy
Messages: 13
Registered: March 2007
Junior Member
Hi

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: 64153
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.

Regards
Michel
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: 1484
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: how to prevent Insert in Before Insert trigger???
Next Topic: how to null value replace' !'
Goto Forum:
  


Current Time: Sun Dec 11 04:28:19 CST 2016

Total time taken to generate the page: 0.04827 seconds