Re: Commit in batch

Hello!
You have two good chances to succeed;

1a) Have a look on maxextents on your temporary TS, it could be that maxextents is to low.

1b) If not then you have to resize the datafile of the TS;

2) Use a PLS/SQL For-Loop ...

NN PLS_INTEGER := 0;
FOR REC IN ( SELECT * FROM TABLE1 )
DO

     INSERT INTO TABLE2 (col1, col2) Values ( REC.col2, Rec.col2 ...);
NN := nn +1;
IF ( MOD(NN , 1000) = 0
   Commit;
END IF; ...;
DONE

• Do not forget last commit; Commit;

Please check syntax i made it quickly

Bye

Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning <!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free! Received on Thu May 25 2000 - 00:00:00 CDT