Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> size limit on insert into target select * from src ?
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