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