Re: Getting the schema of a View

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Jul 2006 10:26:27 -0700
Message-ID: <1152293191.756322_at_bubbleator.drizzle.com>


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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 07 2006 - 19:26:27 CEST

Original text of this message