Global Temporary table location?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Global Temporary table location?

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    Global Temporary table location?

    Hi all,
    I have two tables of the nature....

    CREATE GLOBAL TEMPORARY TABLE XXXXXXXXXXXXX
    (
    xxxxxx
    xxxxxx
    xxxxx
    xxxxx
    xxxxx
    xxxxx
    )
    ON COMMIT PRESERVE ROWS
    NOCACHE;

    Where do these tables reside? as in tablespace? They don't show any tablespace......
    Thanks
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    In the assigned temp tablespace for the user. The definition of it get stored in the data dictionary.

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2001
    Posts
    200
    Quote Originally Posted by sambavan
    In the assigned temp tablespace for the user. The definition of it get stored in the data dictionary.

    Thanx,
    Sam
    Thanks a bundle
    Life is what is happening today while you were planning tomorrow.

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