RE: What OEM table stores the list of databases
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- Date: Fri, 23 Jul 2004 10:14:18 -0400
I had been looking at smp_vdn_target_lists but these two views are more
concise. Thanks.
>>> thomas.mercadante@xxxxxxxxxxxxxxxxx 7/23/04 9:49:56 AM >>>
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
