Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!feed2.newsreader.com!newsreader.com!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>
Organization: Black Hole, Inc.
Message-ID: <Xns96D1483E252B9SunnySD@68.6.19.6>
User-Agent: Xnews/5.04.25
Lines: 13
Date: Wed, 14 Sep 2005 14:06:06 GMT
NNTP-Posting-Host: 68.7.204.31
X-Complaints-To: abuse@cox.net
X-Trace: fed1read03 1126706766 68.7.204.31 (Wed, 14 Sep 2005 10:06:06 EDT)
NNTP-Posting-Date: Wed, 14 Sep 2005 10:06:06 EDT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251483

"g3000" <carlton_gregory@yahoo.com> wrote in 
news:1126705798.012355.18740@g49g2000cwa.googlegroups.com:

> Im on Win2k3 server Standard Ed.
> Oracle9i ( 9.2.0.6 )
> 
> Creating several temp tables that are transaction specific.

WHY?
This smell like a MS-SQLServer code being ported to Oracle.
Only in rare case are temporary tables needed in Oracle.

What problem are you really trying to solve?