Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> oracle equiv. of SQLServer DMO?
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