Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news-han1.dfn.de!news-stu1.dfn.de!news.belwue.de!news.uni-stuttgart.de!carbon.eu.sun.com!btnet-feed5!btnet!news.btopenworld.com!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Where is a temp tables DDL stored? Date: Thu, 15 Sep 2005 14:58:01 +0000 (UTC) Organization: BT Openworld Lines: 67 Message-ID: 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> NNTP-Posting-Host: host86-130-255-217.range86-130.btcentralplus.com X-Trace: nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com 1126796281 11225 86.130.255.217 (15 Sep 2005 14:58:01 GMT) X-Complaints-To: news-complaints@lists.btinternet.com NNTP-Posting-Date: Thu, 15 Sep 2005 14:58:01 +0000 (UTC) X-RFC2646: Format=Flowed; Response X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MSMail-Priority: Normal X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251602 "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. > > Cheers > Serge > -- > Serge Rielau > DB2 SQL Compiler Development > IBM Toronto Lab 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 ? Here's one for Oracle, by the way, in the SYS account: 1* select * from bootstrap$ where obj# = 0 SQL> / LINE# OBJ# ---------- ---------- SQL_TEXT ---------------------------------------------------- 0 0 CREATE ROLLBACK SEGMENT SYSTEM STORAGE ( INITIAL 11 2K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 32765 OBJNO 0 EXTENTS (FILE 1 BLOCK 9)) -- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle - Volume 1: Fundamentals On-shelf date: Nov 2005 http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 4th Sept 2005