RE: anyone see my DBA_AUDIT_TRAIL ??? (solved) bug or Architecture ?

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_USERNAME                                        VARCHAR2(255)
 USERNAME                                           VARCHAR2(30)
 USERHOST                                           VARCHAR2(128)
 TERMINAL                                           VARCHAR2(255)
 TIMESTAMP                                 NOT NULL DATE
 OWNER                                              VARCHAR2(30)
 OBJ_NAME                                           VARCHAR2(128)
 ACTION_NAME                                        VARCHAR2(27)
 NEW_OWNER                                          VARCHAR2(30)
 NEW_NAME                                           VARCHAR2(128)
 OBJ_PRIVILEGE                                      VARCHAR2(16)
 SYS_PRIVILEGE                                      VARCHAR2(40)
 GRANTEE                                            VARCHAR2(30)
 SESSIONID                                 NOT NULL NUMBER
 ENTRYID                                   NOT NULL NUMBER
 STATEMENTID                               NOT NULL NUMBER
 RETURNCODE                                NOT 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_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------------
> SYS DBA_AUDIT_TRAIL VIEW
> PUBLIC DBA_AUDIT_TRAIL SYNONYM
>
>
> 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: Sinardy Xing
  INET: SinardyXing_at_bcs-ach.com.sg

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: ListGuru_at_fatcity.com (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).