Re: size limit on insert into target select * from src ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 29 Oct 2002 10:14:41 +1000
Message-ID: <6ljv9.64466$g9.181302@newsfeeds.bigpond.com>

Hi Kenny,

As you suggest, the size of your RBSs (or the size of the tables themselves) would be limiting factors in how much data you can insert at a time.

The append or parallel hints would "increase" this limit from the RBS point of view due to the substantially reduced undo that is generated.

Cheers

Richard
"Kenny Yu" <kyu_at_biodiscovery.com> wrote in message news:urr7kugm5hj3e9_at_corp.supernews.com...
> Is there limit on the size of data for query
> insert ino target_table select * from source_table;
> ?
> How would the hint /*+ append */ affect that? I have been able to run ttis
> on fairly large (10000 rows) tables. But wonder if I will eventually run
> into some limits. Seems that it should be dependent on the size of RBS.
>
> Kenny
>
>
Received on Mon Oct 28 2002 - 18:14:41 CST