Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!news-lond.gip.net!news.gsl.net!gip.net!colt.net!feeder.news-service.com!80.239.144.83.MISMATCH!newspeer1.de.telia.net!newspeer4.de.telia.net!de.telia.net!nx01.iad01.newshosting.com!newshosting.com!207.115.63.142.MISMATCH!newscon02.news.prodigy.com!newscon06.news.prodigy.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!bcklog1.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 07 Jul 2006 00:48:19 -0500
From: "David C. Barber" <david@NOSPAMdbarber.com>
Newsgroups: comp.databases.oracle.tools
Subject: Getting the schema of a View
Date: Thu, 6 Jul 2006 22:49:12 -0700
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID: <0aidnRnq_p8-aDDZnZ2dnUVZ_r-dnZ2d@comcast.com>
Lines: 16
NNTP-Posting-Host: 69.136.114.66
X-Trace: sv3-Pq5+z9ItBLRgmcywt7bkp0Pkhk6whLjhzHKJz14shevYfd+MVV7VSc1r9R50/nwobPpfMimPaAnO6X5!8jBndTH91GepEWZgWEXSP2qLzgQfqniBG434+LImZVWV0O3ek6K4doNHqoOPPGET2+Y247zfi2En!nTBjxO5BnLopvHFzSDg=
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.32
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:71084

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!