You don't say which version you are using but some versions of 8 had a
problem with
desc and synonyms. Try desc sys.dba_audit_trail and see if that works.
I know this
was a problem in early 8.0 (8.03, 8.0.4) but thought it was fixed by 8i.
John
[EMAIL PROTECTED] wrote:
>Hi,
>
>Is this characteristic of a bug or is the Oracle Architecture ?
>
>SQL> desc dba_audit_exists
>ERROR:
>ORA-24372: invalid object for describe
>
>
>SQL> select count(*) from dba_audit_exists;
>
> COUNT(*)
>--
> 0
>
>SQL> desc dba_audit_exists
> Name Null?Type
> -
> OS_USERNAMEVARCHAR2(255)
> USERNAME VARCHAR2(30)
> USERHOST VARCHAR2(128)
> TERMINAL VARCHAR2(255)
> TIMESTAMP NOT NULL DATE
> OWNER VARCHAR2(30)
> OBJ_NAME VARCHAR2(128)
> ACTION_NAMEVARCHAR2(27)
> NEW_OWNER VARCHAR2(30)
> NEW_NAME VARCHAR2(128)
> OBJ_PRIVILEGE VARCHAR2(16)
> SYS_PRIVILEGE VARCHAR2(40)
> GRANTEEVARCHAR2(30)
> SESSIONID NOT NULL NUMBER
> ENTRYID NOT NULL NUMBER
> STATEMENTID NOT NULL NUMBER
> RETURNCODENOT NULL NUMBER
>
>
>
>Sinardy
>
>
>> -Original Message-
>>From: Sinardy Xing
>>Sent: 08 April 2002 11:41
>>Subject: anyone see my DBA_AUDIT_TRAIL ???
>>
>>Hi guys,
>>
>>Please help me solved this
>>
>>
>>SQL> show user
>>USER is "SYS"
>>
>>
>>SQL> select owner, object_name, object_type from all_objects where object_name =
>'DBA_AUDIT_TRAIL';
>>
>>OWNER OBJECT_NAMEOBJECT_TYPE
>>-- -- --
>>SYSDBA_AUDIT_TRAILVIEW
>>PUBLIC DBA_AUDIT_TRAILSYNONYM
>>
>>
>>SQL> desc DBA_AUDIT_TRAIL
>>ERROR:
>>ORA-24372: invalid object for describe
>>
>>
>>Why I can not describe my DBA_AUDIT_TRAIL ?
>>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ora NT DBA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).