RE: Oracle Baselines and Java Internals
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 07:51:49 -0400
Jared,
I ran your query in 8.1.7.4 and 9.2.0.4 and got no rows back. 817 on NT &
92 on IBM/AIX. I have Java installed in both databases.
Strange?
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx]
Sent: Tuesday, July 20, 2004 8:40 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle Baselines and Java Internals
> > 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@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:
