Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query $ORACLE_HOME

Re: query $ORACLE_HOME

From: Dave <x_at_x.com>
Date: Wed, 17 Nov 2004 18:59:11 GMT
Message-ID: <3cNmd.16927$up1.15146@text.news.blueyonder.co.uk>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US