Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Baselines and Java Internals

RE: Oracle Baselines and Java Internals

From: <Jared.Still_at_radisys.com>
Date: Tue, 20 Jul 2004 17:40:22 -0700
Message-ID: <OF8BFC847C.0C66D966-ON88256ED8.00030FED-88256ED8.0003B2F4@radisys.com>


> > Jared,
> >
> > >Track DDL_TIME, CREATION_DATE and TIMESTAMP for all objects.
> >

In the process of poking around in the data dictionary, I find that there are objects in sys.source$ that do not appear anywhere else. This is on 9.2.0.4.

What appears are objects, all triggers, that have been created at one time, but no longer appear in dba_triggers or sys.obj$.

The following SQL will dump source from sys.source$ that does not have a corresponding object ID in sys.obj$.

col obj# format 9999999
col line format 9999999
col source format a100
set line 130

select obj#, line,source
from sys.source$ o
where o.obj# in (

        select distinct obj#
        from sys.source$
        minus
        select s.obj#
        from dba_objects d, sys.source$ s
        where d.object_id = s.obj#

)
order by 1,2
/

I've just checked a 10g database, and it also has source that no longer appears in any DBA views.

Anyone have a possible explanation?

Jared



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------
Received on Tue Jul 20 2004 - 19:37:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US