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

In the assigned temp tablespace for the user. The definition of it get stored in the data dictionary.

Thanx,
Sam

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