|Subject:||Re: ProView and Oracle - Missing Column Names
|Date:||Mon, 7 May 2012 21:24:03 -0400
|From:||"Larry DiGiovanni" <nospam@nospam>
Tom Krieg wrote:
> I suspect (although I may be wrong because I often am) that Robert is
> using Paradox to look at Oracle databases to determine the table
> structures and layouts. In which case, using views won't provide the
> information he wants.
If you want to look at the structure of an Oracle database, your no cost
- OEM: Oracle Enterprise Manager - comes with Oracle
- SQL*Plus: Comes with Oracle
- SQL*Developer: a free graphical tool for Oracle, allows a user to browse
database objects by schema and by type
If you want to spend a few bucks, there's always TOAD. I haven't looked at
SQL Maestro but just bookmarked it for later perusing.
I am not a huge fan of SQL*Developer performance (I HATE waiting), but it's
got all the features you need for administration and development as well as
just poking around, and you can't beat the price.
If you throw in SQL*Developer Data Modeler, it'll also render the ER
diagrams through a reverse engineering of the schemas themselves (though for
3600 tables, it might be a little unwieldy - it has a habit of lumping them
in poor locations, graphically).