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@xxxxxxxxx] Sent: Friday, July 23, 2004 9:20 AM To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx 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 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------