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