Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Serge Rielau Newsgroups: comp.databases.oracle.server Subject: Re: Where is a temp tables DDL stored? Date: Fri, 16 Sep 2005 09:20:33 -0400 Lines: 48 Message-ID: <3ovv54F8193lU1@individual.net> 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> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net V/kWNXK7eYZQSTYxwuz7zAfuNklvfaLuGeZcO65VhCcD930ISm User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en In-Reply-To: Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251690 Jonathan Lewis wrote: > "Serge Rielau" wrote in message > news:3ot6mnF7lievU1@individual.net... > >>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. >> > Just playing devil's advocate, but why couldn't > the database reverse engineer the corrected > DDL from the data dictionary as the dictionary > is updated ? Wouldn't that be poor database design? I could settle for a view which composes the DDL from the bits and pieces available. Cheers Serge PS: Does bootstrap contain the scripts to create a database/instance? That would make sense then since this DDL is the cause for what you later find in the catalogs (and which won't change - a lot) PPS: Feisty comments regarding the clearness of "DDL" shall be forfeit. PPPS: I'm not Godfrey. I have never met Daniel despite his numerous invitations to class and I can't type Godfreys long posts without spelling errors as he does. -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab