Re: How to get a list of tables, indexes, and views in a given schema

dominic.morris_at_eidosnet.co.uk (dom) wrote in message news:<c5c9bfea.0301190202.7fe6b8d6_at_posting.google.com>... ...
> in a given Oracle DB, I'd like to now know which sys table(s) to query
> for a list of:
>
> 1) tables
> 2) indexes
> 3) views
>
> within a given Oracle schema. I guess you can see where I'm going with
...

I have developed a simple Java application that uses jdbc to dump a schema structure to a text file. I use this to dump two different schemas and then I use diff to find out what the differences are and come up with a migration script (and yes I know that there are tools that do this but the problem I have is that the structures I'm comparing are in database servers separated by firewalls and I never can have connectivity to both of them at the same time).

I'll be happy to give you the source code if you are interested, just send me an email.

Martin Bertolino Received on Wed Jan 22 2003 - 17:12:42 CET