Re: Looking for "auto commit count" feature

In article <3A31C07C.C5151B5D_at_hotmail.com>,   Frugal Sam <frugalsam_at_hotmail.com> wrote:
> Hi all
>
> We have a statement to the effect :
>
> INSERT into tablename_1
> (SELECT ..... from tablename_2)
>
> We cannot use a cursor and commit every n records. The statement is
> executed and results in 5 million rows being copied from tablename_1
 to
> tablename_2. As a result, we need very large rollback statements which
> we want to avoid.
>
> Is there some init parameter we can set when our database instance
> starts up that would tell Oracle to perform a COMMIT say every 100,000
> rows ?
>
> Thanks.
>
>

check out the copy command. It allows commits after so many records. There are some restrictions though.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rosetta.org
              Ususual disclaimers


Sent via Deja.com http://www.deja.com/
Before you buy.