Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!colt.net!feeder.news-service.com!213.132.189.1.MISMATCH!multikabel.net!feed10.multikabel.net!feeder3.cambrium.nl!feed.tweaknews.nl!63.218.45.10.MISMATCH!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail
Date: Fri, 07 Jul 2006 10:26:27 -0700
From: DA Morgan <damorgan@psoug.org>
Organization: Puget Sound Oracle Users Group
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: Getting the schema of a View
References: <0aidnRnq_p8-aDDZnZ2dnUVZ_r-dnZ2d@comcast.com>
In-Reply-To: <0aidnRnq_p8-aDDZnZ2dnUVZ_r-dnZ2d@comcast.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <1152293191.756322@bubbleator.drizzle.com>
Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 30
X-Complaints-To: abuse@csolutions.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:71091

David C. Barber wrote:
> Hi,
> 
> We have an Oracle 10 (I believe) database, but none of the tools to go with
> it yet due to budget constraints.  You know how it is with Oracle tools.  It
> runs a single vendor application comprising over 1400 tables and views.  Now
> we have to pry open the hood a little bit and get some data out.  The vendor
> documentation is trash, but I have a View that contains the data I'm
> interested in.  My problem is to trace back to the original tables that
> comprise this View.  Can anyone recommend any good Open Source (read: Free)
> tools that can help me with this?  I only have to do this maybe a few number
> of times, which makes it hard to justify investing big bucks otherwise, and
> I don't read DDL myself.
> 
> Thanks!

No tool required. In SQL*Plus type:

SELECT dbms_metadata.get_ddl('VIEW', '<the_name_of_your_view>')
FROM dual;

A full demo can be found in Morgan's Library at www.psoug.org under
DBMS_METADATA.
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org