Database Security Products (MOSC)

MOSC Banner

truncate table sys.aud$ failed

edited Aug 31, 2018 5:02AM in Database Security Products (MOSC) 12 commentsAnswered
 originally posted by Sister DBA(but as a document)

 Hi All:

need advice  - it is a simple test and auditing has been turn-off already; however, one is able to desc,select from aud$, but NOT delete!


SQL> connect / as sysdba
Connected.

SQL> select count(*) from sys.aud$;

  COUNT(*)
----------
  15053519


SQL> truncate table aud$;
truncate table aud$
               *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> truncate table sys.aud$;
truncate table sys.aud$
                   *
ERROR at line 1:
ORA-00942: table or view does not exist

I also tried 'execute immediate 'truncate table sys.aud$' but failed again.  What to do next??

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center