Re: Looking for "auto commit count" feature

You have to break it into several statements. You have to break the insert into a series of ranges. You can use rowid or something on the primary key.. You wouldn't really want to set a system wide event to automatically commit transactions, that could be disasterous..

• Doug
• Oracle certified DBA.

"If everything feels like it's under control, you're probably not going fast enough" - Mario Andretti

On Sat, 09 Dec 2000 05:19:53 GMT, 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.
Received on Sat Dec 09 2000 - 00:03:17 CST