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 -> oracle equiv. of SQLServer DMO?

oracle equiv. of SQLServer DMO?

From: dom <dominic.morris_at_eidosnet.co.uk>
Date: 14 Jan 2003 07:55:54 -0800
Message-ID: <c5c9bfea.0301140755.7f61b7c9@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 - 09:55:54 CST

Original text of this message

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