From oracle-l-bounce@freelists.org Fri Jul 23 09:03:29 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6NE34005547 for ; Fri, 23 Jul 2004 09:03:14 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6NE2n605497 for ; Fri, 23 Jul 2004 09:03:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B67872C7D4; Fri, 23 Jul 2004 08:41:23 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19446-45; Fri, 23 Jul 2004 08:41:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 11BBB72CAB3; Fri, 23 Jul 2004 08:41:22 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 23 Jul 2004 08:39:35 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 83D0D72C3CD for ; Fri, 23 Jul 2004 08:39:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18114-79 for ; Fri, 23 Jul 2004 08:39:14 -0500 (EST) Received: from exchsen0a1rb.dfa.state.ny.us (exchsen0a1rb.dfa.state.ny.us [198.22.236.247]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 180B572C0DD for ; Fri, 23 Jul 2004 08:39:09 -0500 (EST) Received: from snysdolmail1.labor.state.ny.us ([172.16.96.117]) by exchsen0a1rb.dfa.state.ny.us with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id PPQW4T6K; Fri, 23 Jul 2004 09:51:33 -0400 Received: by snysdolmail1.labor.state.ny.us with Internet Mail Service (5.5.2650.21) id ; Fri, 23 Jul 2004 09:49:56 -0400 Message-ID: X-Sybari-Trust: f915317d 60b8330e 5a0a49a6 0000013d From: "Mercadante, Thomas F" To: "'oracle-l@freelists.org'" Subject: RE: What OEM table stores the list of databases Date: Fri, 23 Jul 2004 09:49:56 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5845 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@gcrta.org] Sent: Friday, July 23, 2004 9:20 AM To: oracle-l@freelists.org; ORACLE-L@IC.SUNYSB.EDU; oracledba@lazydba.com; oracle-rdbms@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 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------