If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.