Re: Commit in batch

Chua Boon Yiang wrote in message <8gkrnu$cvs$1_at_newton.pacific.net.sg>...
>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 ?

The other postings show how to increase the space parameters of the temporary tablespace, and how to write PL/SQL to commit every 1000 records, but I'm puzzled why this statement uses the temporary tablespace at all. Are you sure you haven't accidentally created table TABLE1 in the temp_ts tablespace?

Dave.

--
If you reply to this posting by email, remove the "nospam" from my email
address first.