External Table upper limit

Hi Guys,
Will there be a preformance degradation when the number of records in an external table is very huge? Will the select hang ? etc , or can external table handle any amount of data?

Similarly can the Global temporary table handle any amount of data? with preserve rows? or do we have to size the temporary tablespace accordingly ?


Please guide if anyone has come across these types of scenarios.

Thankyou

External table is designed for loading and unloading table data. You should not use it extensively in your select statement b/c of FTS.
There is no limit on its size. It depends upon the size of the file system and the ulimit settings.

For GTT, you need to size temporary tablespace correctly. Again there is no restriction.

Tamil

Hi Tamil ,

thanks fro your answer. I woudl really appreciate if you would give me some links on white papers on External tables and Global Temporary tables .

Thanks