DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: External Table upper limit

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    External Table And Temporary 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
    Last edited by Rohit; 02-16-2005 at 06:09 AM.
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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

  3. #3
    Join Date
    Aug 2002
    Posts
    176
    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
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width