Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: bdbafh@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is a temp tables DDL stored?
Date: 14 Sep 2005 19:04:47 -0700
Organization: http://groups.google.com
Lines: 30
Message-ID: <1126749887.591775.325340@g43g2000cwa.googlegroups.com>
References: <1126705798.012355.18740@g49g2000cwa.googlegroups.com>
   <1126712247.735544@yasure>
   <1126716382.588532.161250@g43g2000cwa.googlegroups.com>
   <bvpgi1d7ntj5keemcfgnjv2hkv8c4n9fg7@4ax.com>
   <1126723858.554220.198110@g43g2000cwa.googlegroups.com>
   <tlugi15lh587l4ifq86cm4mn2j55tf2dbb@4ax.com>
   <1126729301.961774.27730@o13g2000cwo.googlegroups.com>
   <2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g@4ax.com>
NNTP-Posting-Host: 69.142.196.48
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126749891 13545 127.0.0.1 (15 Sep 2005 02:04:51 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 15 Sep 2005 02:04:51 +0000 (UTC)
In-Reply-To: <2c5hi1lcj5ujdr6rkpeq7og4t3ue6n3m0g@4ax.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.10) Gecko/20050716 Firefox/1.0.6,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=69.142.196.48;
   posting-account=rcQZawwAAAALUCo-zZUVUQgj4l_8W6zb
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251561

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