Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx02.iad01.newshosting.com!newshosting.com!news.glorb.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "g3000" <carlton_gregory@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: 14 Sep 2005 07:18:46 -0700
Organization: http://groups.google.com
Lines: 8
Message-ID: <1126707526.762209.164070@f14g2000cwb.googlegroups.com>
References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com>
   <Xns96D1483E252B9SunnySD@68.6.19.6>
NNTP-Posting-Host: 192.171.10.24
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126707535 19549 127.0.0.1 (14 Sep 2005 14:18:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 Sep 2005 14:18:55 +0000 (UTC)
In-Reply-To: <Xns96D1483E252B9SunnySD@68.6.19.6>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 proxy2.scn.spawar.navy.mil:80 (squid/2.5.STABLE3)
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=192.171.10.24;
   posting-account=VJ4T7AwAAABe8mLLNgK9gALeJHW_FS4f
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251486

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

And no, I am not porting MSSQL code.

There is an accurate answer to this question and thats what I am
seeking.