Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-11!sn-xit-05!sn-xit-08!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: Thu, 15 Sep 2005 08:54:41 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1126799628.138852@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> <1126729301.961774.27730@o13g2000cwo.googlegroups.com> <3ot6mnF7lievU1@individual.net> In-Reply-To: <3ot6mnF7lievU1@individual.net> 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: 31 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251617 Serge Rielau wrote: > Daniel Fink 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. >> >> However, all the information to reconstruct this command IS stored in >> the data dictionary and can be extracted using a variety of >> tools/techniques. >> > I'm curious, do you know of any DBSM which store the DDL for a table? > Reason being why this generally is not done is that schema-evolution > either will outdate the DDL text very quickly, or cause a maintenance > nightmare for DBMS developers. > Most systems I know leave it to tooling to reverse engineer the current, > up to date, DDL for a table (and other objects) from the data dictionary. > > Cheers > Serge Taken literally no. But we often use DDL to mean metadata just as, in the Oracle world, we often use the words INSTANCE and DATABASE interchangeably when in fact they are entirely different constructs. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)