Re: Where is a temp tables DDL stored?

From: <bdbafh_at_gmail.com>
Date: 14 Sep 2005 19:04:47 -0700
Message-ID: <1126749887.591775.325340@g43g2000cwa.googlegroups.com>

Sybrand,

It is quite clear to me who is being ignorant of how Oracle "works" in this case.

It appears that you did not provide a query as requested to retrieve the DDL as if it were stored in a table that could be queried such as:

SELECT text
  FROM all_source
WHERE owner='MYAPP'
   AND name='MYPACKAGE'
   AND TYPE='PACKAGE BODY'
ORDER BY line
/

here is a start for you:

SELECT theddl not_using_dbms_metadata
  FROM all_storedddl
WHERE owner='MYAPP'
   AND name='MYTABLE'
   AND TYPE='TABLE'
/

I was perusing dict in a 10g R1 db (10.1.0.4) on win32. I could find no such 'ALL%' view/table.

-bdbafh Received on Wed Sep 14 2005 - 21:04:47 CDT