Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: fitzjarrell@cox.net
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: 14 Sep 2005 14:53:46 -0700
Organization: http://groups.google.com
Lines: 30
Message-ID: <1126734826.778600.267650@g14g2000cwa.googlegroups.com>
References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com>
   <1126712247.735544@yasure>
   <1126716382.588532.161250@g43g2000cwa.googlegroups.com>
   <bvpgi1d7ntj5keemcfgnjv2hkv8c4n9fg7@4ax.com>
   <1126723858.554220.198110@g43g2000cwa.googlegroups.com>
   <tlugi15lh587l4ifq86cm4mn2j55tf2dbb@4ax.com>
   <1126729301.961774.27730@o13g2000cwo.googlegroups.com>
   <2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g@4ax.com>
NNTP-Posting-Host: 68.95.47.225
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126734832 26817 127.0.0.1 (14 Sep 2005 21:53:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 Sep 2005 21:53:52 +0000 (UTC)
In-Reply-To: <2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g@4ax.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=68.95.47.225;
   posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251541


Sybrand Bakker wrote:
> On 14 Sep 2005 13:21:42 -0700, "Daniel Fink" <danielwfink@yahoo.com>
> wrote:
>
> >I think we are disagreeing over semantics.
> >
> >I consider DDL to be the command that creates (or modifies) the object,
> >i.e. CREATE TABLE emp <...>; This command is not stored in the data
> >dictionary.
>
> I don't think we are disagreeing over semantics. It is quite clear you
> are ignorant of how Oracle works, and expect it to work the same way
> as a toy system like MySQL or sqlserver. In that case, please: dream
> on.
>
> --
> Sybrand Bakker, Senior Oracle DBA

I must agree with Daniel on this; there is no explicit DDL stored in
the data dictionary, however the definitions for objects ARE stored
there, and it's not a serious leap to take that information and
generate the associated DDL.

It appears he does know how Oracle works.  And, in my opinion, you are
disagreeing on semantics.


David Fitzjarrell