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