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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What's special about this create table statement?

Re: What's special about this create table statement?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 5 Jan 2006 06:19:04 -0500
Message-ID: <F7ednXsw2JU0nSDeRVn-jg@comcast.com>

"dean" <deanbrown3d_at_yahoo.com> wrote in message news:1136437699.555479.15420_at_z14g2000cwz.googlegroups.com...
>I got it from the EM console. I right-clicked on the table and then on
> Show Object DDL...
>
> If this is coming up wrong, could you tell me if there is another way
> to get the create table statement? Originally this was a global temp
> table, and perhaps it still is, I am just confused why its not showing
> up this way in the ddl.
>
> Thanks for so far!
>
> Dean
>

select table_name, temporary
from user_tables
where....

that will let you know if it is (still) a global temporary table

++ mcs Received on Thu Jan 05 2006 - 05:19:04 CST

Original text of this message

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