Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!news.tele.dk!news.tele.dk!small.news.tele.dk!sn-xit-03!sn-xit-08!sn-post-02!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: Fri, 16 Sep 2005 22:13:04 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1126933938.541697@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> <1126904873.419638.129300@g47g2000cwa.googlegroups.com> In-Reply-To: <1126904873.419638.129300@g47g2000cwa.googlegroups.com> 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: 33 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251733 mikharakiri_nospaum@yahoo.com wrote: > Jonathan Lewis wrote: > >>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 ? > > > To extend this idea further, I always wondered why the concept of DDL > is needed at all? Consider > > -- create 100 tables TEST1...TEST100 > insert into user_tables -- or, more concervatively, tab$ > as select 'TEST'||rownum table_name, ... > from dual connect by rownum < 100 > > insert into user_tab_columns -- or, more concervatively, col$ > ... > > commit; A table that isn't in obj$ or col$ or seg$, etc. What a fascinating way to destroy an Oracle system. Have you actually tried this? Were you immediately fired? I hope no one tries this. Devil's advocate indeed. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)