Temporary tables and quotas on TEMP tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Temporary tables and quotas on TEMP tablespace

  1. #1
    Join Date
    Jun 2005
    Posts
    2

    Temporary tables and quotas on TEMP tablespace

    Hi,

    Sorting does not require any quotas on TEMP tablespace, as sorting is done by the system on behalf of the (DB) user.

    How about dynamic SQL, which generates temporary tables ?
    Do users need quota on TEMP tablespace for that - otherwise they won't be able to create and /or fill such tables ?

    Thanks in advance,

    Tajci

  2. #2
    Join Date
    Mar 2002
    Posts
    534
    Have you tried out?

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    Instead of creating temporary tables using dynamic SQL, why not use global temporary tables:

    http://www.oracle-base.com/articles/...raryTables.php

    It's going to be allot faster than issuing DDL statements.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  4. #4
    Join Date
    Jun 2005
    Posts
    2
    Thanks for replies.

    --------- o O o ---------

    As far as I understood that, temporary tables are always created in the default temporary tablespace of the user creating (records in ) a temporary table.

    Is this correct ?

    The main question was:
    Temporary or global temporary tables -
    Whose quotas do temporary tables consume ?
    Or, in other words:
    Does a user need quotas on temporary tablespace to create /and or insert into temporary tables ???

    Or is it the system who creates temp tables or records on behalf of the user issuing an insert (or create) - as for sorting applies ?

    Thanks in advance,

    Tajci

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