Paradox Community

Items in pnews.paradox-3rdparty

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 
options are:

- 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).

Larry DiGiovanni 

Copyright © 2004