RE: What OEM table stores the list of databases
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Jul 2004 10:12:18 -0400
That's an option but that way would have to ensure the scripts are in
all databases. Also, there is no way to automatically purge jobs from
the job history.
>>> asahoshi@xxxxxxxxxxxxxx 7/23/04 9:59:10 AM >>>
Why not register the jobs in OEM and then just select all the databases
as
targets?
> [Original Message]
> From: Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>; <ORACLE-L@xxxxxxxxxxxxx>;
<oracledba@xxxxxxxxxxx>; <oracle-rdbms@xxxxxxxxxxxxxxx>
> Date: 7/23/2004 9:21:32 AM
> 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:
