| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Baselines and Java Internals
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_at_radisys.com [mailto:Jared.Still_at_radisys.com]
Sent: Tuesday, July 20, 2004 8:40 PM
To: oracle-l_at_freelists.org
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#
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
-- 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_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 Wed Jul 21 2004 - 06:51:26 CDT
 |
 |