Commit in batch

Hi

i am using an

INSERT INTO TABLE1
select * from TABLE2.

But i keep hitting temp_ts is not enough message. May i know is there anyway to commit say every 1000 records inserted into TABLE1 ?

Thanks
Boon Yiang Received on Fri May 26 2000 - 00:00:00 CDT