Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> size limit on insert into target select * from src ?

size limit on insert into target select * from src ?

From: Kenny Yu <kyu_at_biodiscovery.com>
Date: Mon, 28 Oct 2002 12:36:35 -0800
Message-ID: <urr7kugm5hj3e9@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 - 14:36:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US