Delete Records - DJW [message #2270] |
Wed, 03 July 2002 00:11 |
Danie
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
Hi All
I have a table with millions of records.
I want to delete some of the records but my temp space is not enough for the transaction. I need to send a commit after deleteing a couple of thousand records.
Any Ideas as to do this.
Thanx
DJW
|
|
|
Re: Delete Records - DJW [message #2271 is a reply to message #2270] |
Wed, 03 July 2002 00:40 |
Arvind L
Messages: 27 Registered: June 2001
|
Junior Member |
|
|
Hi,
You can use SET AUTOCOMMIT ON option before you issue your delete statement. With this option you need not issue commit explicitly.
Reg,
Arvind
|
|
|