Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "Daniel Fink" <danielwfink@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: 14 Sep 2005 09:46:22 -0700
Organization: http://groups.google.com
Lines: 8
Message-ID: <1126716382.588532.161250@g43g2000cwa.googlegroups.com>
References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com>
   <1126712247.735544@yasure>
NNTP-Posting-Host: 216.88.130.72
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126716389 32229 127.0.0.1 (14 Sep 2005 16:46:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 Sep 2005 16:46:29 +0000 (UTC)
In-Reply-To: <1126712247.735544@yasure>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=216.88.130.72;
   posting-account=P-kTng0AAAD3g70oUy_l14RYHR_8opyJ
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251506

The DDL for tables is not stored in the data dictionary, though the
necessary components to reconstruct the DDL for tables are stored
there. That is why we have had to use OEM, export, dbms_metadata and
3rd party tools to extract the DDL when needed.

Regards,
Daniel Fink