Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!headwall.stanford.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Where is a temp tables DDL stored? Date: Wed, 14 Sep 2005 21:33:46 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: sybrandb@hccnet.verwijderdit.nl References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com> <1126712247.735544@yasure> <1126716382.588532.161250@g43g2000cwa.googlegroups.com> <1126723858.554220.198110@g43g2000cwa.googlegroups.com> X-Newsreader: Forte Agent 3.0/32.763 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 18 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251520 On 14 Sep 2005 11:50:58 -0700, "Daniel Fink" wrote: >Where is the ddl stored? Where do you find "create table..."? > >The components of the ddl are stored, you can extract them into a form >that will give you a command to create the table. So the DDL is stored, isnt' it? And of course you can save the create table command to a .sql script easily. Also you can run export with rows=n and dump the create table command easily. I really don't see the problem, and I don't think your assertion is correct. -- Sybrand Bakker, Senior Oracle DBA