Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where is a temp tables DDL stored?

Re: Where is a temp tables DDL stored?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Sep 2005 21:33:46 +0200
Message-ID: <tlugi15lh587l4ifq86cm4mn2j55tf2dbb@4ax.com>


On 14 Sep 2005 11:50:58 -0700, "Daniel Fink" <danielwfink_at_yahoo.com> 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
Received on Wed Sep 14 2005 - 14:33:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US