Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle equiv. of SQLServer DMO?
In article <c5c9bfea.0301140755.7f61b7c9_at_posting.google.com>,
dominic.morris_at_eidosnet.co.uk says...
> 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...
>
Probably the safest bet is to just parse tnsnames.ora and extract the service names. That's how other tools do it.