Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query $ORACLE_HOME
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
Received on Wed Nov 17 2004 - 12:25:36 CST