Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What's special about this create table statement?
"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