Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query $ORACLE_HOME
"Ed Stevens" <nospam_at_noway.nohow> wrote in message
news:0o5np059uk55bv370rud6frpvpn5i6kk8i_at_4ax.com...
> On Wed, 17 Nov 2004 13:10:36 -0500, robert <rchin_at_nietspampanix.com>
> wrote:
>
>>Connor McDonald wrote:
>>> check dbms_system
>>
>>hmm why I dont have dbms_system ?
>>
>>Connected to:
>>Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
>>With the Partitioning, OLAP and Data Mining options
>>
>>SQL> select user from dual;
>>
>>USER
>>------------------------------
>>SYSTEM
>>
>>SQL> desc dbms_system
>>ERROR:
>>ORA-04043: object dbms_system does not exist
>>
>
> It's a package, not a table or view.
>
> SQL> select owner, object_name, object_type
> 2 from dba_objects where object_name = 'DBMS_SYSTEM';
>
> OWNER OBJECT_NAME OBJECT_TYPE
> -------- -------------------- --------------------
> SYS DBMS_SYSTEM PACKAGE
> SYS DBMS_SYSTEM PACKAGE BODY
>
> SQL> desc dbms_system;
> ERROR:
> ORA-04043: object dbms_system does not exist
>
you know you an describe a package, desc it as sys as there isnt a synonym for it Received on Wed Nov 17 2004 - 12:59:11 CST