Commit

From: Eddie <Edward_Harford_at_Hotmail.com>
Date: 2 Jul 2004 05:15:16 -0700
Message-ID: <e8440de7.0407020415.75f317e8@posting.google.com>

Hi,

I am sure this is a obvious thing, but I have a SQL statement which goes something like....

Insert into table ( field1,field2..) (Select field1,field2 from big_Table)

THe big_Table is approx 3 million rows.

Needless to say I am getting "unable to extend temp segment by in tablespace "

Rather then increasing various segments etc. Is there a way I can make it to commit every 1000 inserts. Does this need to be done in PL/SQL as a loop it can I set an autocommit on x inserts ?

Cheers Eddie Received on Fri Jul 02 2004 - 07:15:16 CDT