| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: What OEM table stores the list of databases
Jeff,
Look at the Smp_View_Targets and Smp_View_Target_Properties views. You should be able to get everything you need from these.
Did you look at the elements in the repository? I found these in about 1 minute.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
Sent: Friday, July 23, 2004 9:20 AM
To: oracle-l_at_freelists.org; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_lazydba.com;
oracle-rdbms_at_yahoogroups.com
Subject: What OEM table stores the list of databases
I am looking at creating jobs to go against all of our databases. Since they are all registered in OEM, I was hoping to query a OEM table to get all of the database names. Anybody what OEM table this is stored in.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |