Jared,
There was some discussion about this at IOUG.
Apparently, in 10G there are now dba views that
require OEM or some other purchased tools to access.
Lots of grumbling on the part of DBAs about not having
full access to the data dictionary without spending
more money but no real explanation by Oracle.
Pete
- Jared.Still_at_radisys.com wrote:
> > > 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
>
>
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
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 - 09:13:29 CDT