Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!tethys.csu.net!nntp.csufresno.edu!sn-xit-03!sn-xit-10!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: Wed, 14 Sep 2005 20:50:04 -0700
Organization: Ye 'Ol Disorganized NNTPCache groupie
Message-ID: <1126756149.648640@yasure>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> <1126712247.735544@yasure> <1126716382.588532.161250@g43g2000cwa.googlegroups.com> <1126723858.554220.198110@g43g2000cwa.googlegroups.com>
In-Reply-To: <1126723858.554220.198110@g43g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@oracle.advtechserv.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 22
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251570
Daniel Fink wrote:
> Where is the ddl stored? Where do you find "create table..."?
>
> The components of the ddl are stored, you can extract them into a form
> that will give you a command to create the table.
I think the issue here is semantic.
Where in source$ is 'CREATE OR REPLACE' stored for a PL/SQL object?
No one would argue the point that the DDL for a stored procedure
is in source$. So why the issue about DDL for a table?
I most certainly understand the point but the lack of CREATE
doesn't make or break either side's case. Lets not take this
one further than where it is. We all know what is in tab$ and
col$ and what is not.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)