On Wed, 17 Nov 2004 18:59:11 GMT, "Dave" <x_at_x.com> wrote:
>
>"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
>
Learn something every day! Thanks.
Received on Thu Nov 18 2004 - 08:05:30 CST
