Re: Getting the schema of a View

"David C. Barber" <david_at_NOSPAMdbarber.com> wrote in message news:0aidnRnq_p8-aDDZnZ2dnUVZ_r-dnZ2d_at_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!
>
>
Received on Fri Jul 07 2006 - 09:17:31 CEST