Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsgate.cistron.nl!xs4all!transit4.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
From: "GuessWho" <nomail@please.com>
Newsgroups: comp.databases.oracle.tools
References: <0aidnRnq_p8-aDDZnZ2dnUVZ_r-dnZ2d@comcast.com>
Subject: Re: Getting the schema of a View
Date: Fri, 7 Jul 2006 09:17:31 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
Lines: 32
Message-ID: <44ae0bac$0$31640$e4fe514c@news.xs4all.nl>
NNTP-Posting-Host: 82.92.122.102
X-Trace: 1152256940 news.xs4all.nl 31640 [::ffff:82.92.122.102]:16650
X-Complaints-To: abuse@xs4all.nl
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:71085


"David C. Barber" <david@NOSPAMdbarber.com> wrote in message
news:0aidnRnq_p8-aDDZnZ2dnUVZ_r-dnZ2d@comcast.com...
> 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.

Oracle SQL Developer is free! Downloadable from otn.oracle.com.
R.

> 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!
>
>