Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.moat.net!nntp.waia.asn.au!203.59.27.186.MISMATCH!newsfeed.iinet.net.au!newsfeed.iinet.net.au!per-qv1-newsstorage1.iinet.net.au!per-qv1-newsstorage1.iinet.net.au!per-qv1-newsreader-01.iinet.net.au!not-for-mail Message-ID: <43297319.2874@yahoo.com> Date: Thu, 15 Sep 2005 21:11:53 +0800 From: Connor McDonald Reply-To: connor_mcdonald@yahoo.com X-Mailer: Mozilla 3.01 (WinNT; I) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Where is a temp tables DDL stored? 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> <2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g@4ax.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 36 NNTP-Posting-Host: 203.59.118.201 X-Trace: 1126789910 per-qv1-newsreader-01.iinet.net.au 12705 203.59.118.201 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251593 Sybrand Bakker wrote: > > On 14 Sep 2005 13:21:42 -0700, "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. > > 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 Sybrand, for all your pontificating about people who should have done their research on their list before posting, you really have made a complete fool of yourself this time -- Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable" web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@yahoo.com "Semper in excremento, sole profundum qui variat." ------------------------------------------------------------