Re: Commit

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 02 Jul 2004 14:07:56 GMT
Message-ID: <0%dFc.13673$XM6.546@attbi_s53>

"Eddie" <Edward_Harford_at_Hotmail.com> wrote in message news:e8440de7.0407020415.75f317e8_at_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

You are getting the error because you probably have an order by in the select. Remove the order by. There is no autocommit in pl/sql. You will just slow things down by committing every 1,000 records. Jim Received on Fri Jul 02 2004 - 09:07:56 CDT