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: "William Robertson" <william.robertson@bigfoot.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: 17 Sep 2005 17:04:33 -0700
Organization: http://groups.google.com
Lines: 38
Message-ID: <1127001873.080941.316050@g43g2000cwa.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>
   <3ot6mnF7lievU1@individual.net>
   <1126799628.138852@yasure>
   <1126800098.081767.80510@o13g2000cwo.googlegroups.com>
   <1126800874.248231@yasure>
   <1126809362.916476.27400@g14g2000cwa.googlegroups.com>
   <1126811679.56932@yasure>
NNTP-Posting-Host: 82.45.232.110
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1127001878 20321 127.0.0.1 (18 Sep 2005 00:04:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 18 Sep 2005 00:04:38 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; 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=82.45.232.110;
   posting-account=14FQPQ0AAACEKI6mOeO_Or9AVEx3kAMJ
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251765

DA Morgan wrote:
> Daniel Fink wrote:
> > As soon as I saw DCL, I thought Digital Command Language! Recycling
> > acronyms is a great way to confuse people!
> >
> > Ah, fond memories of VMS...
> >
> > Daniel Fink
>
> Someone could probably write a book on just the subject of Oracle
> recycling names within a single product family.
>
> How many definitions for the word "block"?
>
> Three come to mind immediately.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan@x.washington.edu
> (replace x with u to respond)

I always liked the way Oracle tried to claim that "JSP" stood for "Java
Stored Procedures".

It seems to me that one difference between DDL and metadata is in
intentionality. When creating a partitioned table, for example, you
might deliberately not define individual storage clauses or tablespace
names for individual partitions, because you want them all to use the
settings defined at the table level. When reverse-engineering the DDL
from the data dictionary later, there is nothing to tell you that the
person who created the table had that in mind, so typically tools such
as exp/imp specify every setting for each partition. The result is
semantically different to what was used originally, even if it produces
the same result, but there is no way to tell that from the metadata.

I don't think that helps the OP very much but I do enjoy a bit of
semantics.