Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!news-feed01.roc.ny.frontiernet.net!nntp.frontiernet.net!cox.net!news-xfer.cox.net!p01!fed1read03.POSTED!53ab2750!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
From: "IANAL_VISTA" <IANAL_Vista@hotmail.com>
References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> <Xns96D1483E252B9SunnySD@68.6.19.6> <1126707526.762209.164070@f14g2000cwb.googlegroups.com>
Organization: Black Hole, Inc.
Message-ID: <Xns96D14EC2B855CSunnySD@68.6.19.6>
User-Agent: Xnews/5.04.25
Lines: 16
Date: Wed, 14 Sep 2005 14:44:33 GMT
NNTP-Posting-Host: 68.7.204.31
X-Complaints-To: abuse@cox.net
X-Trace: fed1read03 1126709073 68.7.204.31 (Wed, 14 Sep 2005 10:44:33 EDT)
NNTP-Posting-Date: Wed, 14 Sep 2005 10:44:33 EDT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251492

"g3000" <carlton_gregory@yahoo.com> wrote in 
news:1126707526.762209.164070@f14g2000cwb.googlegroups.com:

> My question is how does Oracle determine where the DDL for the temp
> table is stored?
> 

The DDL is stored in the Data dictionary.
The above question is very different from your original; below.

> Can I define a tablespace for a temp table as I do for a regular table?

Yes, tablespace can be specified regardless of table type.

All of the above still begs the question as to WHY you think a "temp" table 
is actually needed.