Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle equiv. of SQLServer DMO?

Re: oracle equiv. of SQLServer DMO?

From: tojo <Tojo_at_hotmail.com>
Date: Wed, 15 Jan 2003 11:19:33 +0100
Message-ID: <MPG.188f541bca83ebce9896e0@news.t-online.de>


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.

Received on Wed Jan 15 2003 - 04:19:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US