Re: oracle equiv. of SQLServer DMO?

Alistair Thomson wrote:

> Hi
>
> I think you might be looking for Oracle Enterprise Manager (OEM) it does all
> that you ask below.
>
> Alistair
>
> "dom" <dominic.morris_at_eidosnet.co.uk> wrote in message
> news:c5c9bfea.0301140755.7f61b7c9_at_posting.google.com...
> > Hi all,
> > WARNING: oracle newbie!
> >
> > I'd like to get hold the Oracle equiv. of the Microsoft SQLDMO DLL.
> > Basically, I'd like a Win32 component which provided a list of Oracle
> > servers on the network, for each of these, a list of DBs (schemas?,
> > terminology mismatch?) in it, for each DB a list of tables & procs,
> > for each table a list of columns and info on each column, for each
> > proc its text., etc. etc.
> >
> > If there isn't a pre-packaged DLL that will do this job, I need to
> > write one myself. I figure that once I'm logged into a server, I can
> > query the system tables for most of this, but the top-level (i.e. list
> > of available Oracle servers on the network) is stumping me. I'd prefer
> > that the user selects the Oracle server he wants to connect to from a
> > listbox, rather than have to enter the server SID(?) into a textbox...
> >
> > Any & all advice is greatly appreciated.
> > DM.

And do keep in mind that Oracle, unlike SQL Server, is not Windows-centric. So a DLL is not going to be a likely solution to any problem.

Daniel Morgan Received on Tue Jan 14 2003 - 15:50:11 CST