OraFAQ Forum: Server Administration » unable to see dba_audit

Home » RDBMS Server » Server Administration » unable to see dba_audit_trail (oralce 11g -- 11.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to see dba_audit_trail [message #654440]

Wed, 03 August 2016 01:32

Prakash Singh
Messages: 1
Registered: August 2016

Junior Member

SQL> desc dba_audit_trail;
ERROR:
ORA-24372: invalid object for describe

--plz help me...

Report message to a moderator

Re: unable to see dba_audit_trail [message #654441 is a reply to message #654440]

Wed, 03 August 2016 01:35

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ask your DBA to grant you access to it (if you are allowed to have this access).

Report message to a moderator

Re: unable to see dba_audit_trail [message #654445 is a reply to message #654441]

Wed, 03 August 2016 02:42

Frank Naude
Messages: 4571
Registered: April 1998

Senior Member

Or if it really doesn't exist, connect to SYS and run cataudit.sql to create it.

conn SYS AS SYSDBA
@?/rdbms/admin/cataudit.sql

Report message to a moderator

Re: unable to see dba_audit_trail [message #654449 is a reply to message #654445]

Wed, 03 August 2016 03:24

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

24372, 00000, "invalid object for describe"
// *Cause:  The object to be described is not valid.
//          It either has compilation or authorization errors.
// *Action: The object to be described must be valid.

Report message to a moderator

Previous Topic:	Oracle Universal installer stucks - GUI issue?
Next Topic:	how connect with 12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 28 00:39:38 CDT 2023