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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 14 Sep 2005 20:50:04 -0700
Message-ID: <1126756149.648640@yasure>


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.

I think the issue here is semantic.

Where in source$ is 'CREATE OR REPLACE' stored for a PL/SQL object?

No one would argue the point that the DDL for a stored procedure is in source$. So why the issue about DDL for a table?

I most certainly understand the point but the lack of CREATE doesn't make or break either side's case. Lets not take this one further than where it is. We all know what is in tab$ and col$ and what is not.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Sep 14 2005 - 22:50:04 CDT

Original text of this message

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