How to Commit in intervals
300309Jan 30 2007 — edited Feb 13 2007Hi,
I have a situation where in I have to insert and update records in Bulk.
The insert statement is of the type -
INSERT INTO <tname> (col1, col2)
SELECT col1, co2 FROM <tname2>
Here my <tname2> table has million of records and my temp space gets filled up if I try to insert it at one go. I think this is because I am having a single commit and the records remain in the temp table space till that time.
Is there a mechanism of getting around this and be able to commit , say after every 10,000 records.
Regards
Deepak