Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle equiv. of SQLServer DMO?
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.
Received on Tue Jan 14 2003 - 10:13:12 CST