Re: Commit

> 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 ?

exp/imp?

-- 
wbr,
Wit.