Audit problem - could you help?

I am attempting to set up auditing for the first time. I tried to turn on auditing for the following, which according to the Oracle admin manual (tables 13-1 & 13-2) are all valid options:

CREATE TABLE
TRUNCATE TABLE
DROP TABLE
ALTER TABLE
DELETE TABLE
GRANT TABLE
INSERT TABLE
LOCK TABLE
UPDATE TABLE Most options work, e.g.
>AUDIT CREATE TABLE BY SESSION;
>Audit succeeded.

For some reason the DROP and TRUNCATE options refuse to be set; instead I get the error:
AUDIT TRUNCATE TABLE BY SESSION
      *
ERROR at line 1:
ORA-00956: missing or invalid auditing option // *Cause: AUDIT statement contains an invalid auditing option. // *Action: Use a valid option.

but as far as I can see from the manual it IS valid.

Any ideas?

By the way I have turned auditing on in the init.ora file and as system seem to have all the privs I need: SQLDBA> SELECT * from DBA_SYS_PRIVS where GRANTEE = 'SYSTEM';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
SYSTEM                         AUDIT ANY                                NO
SYSTEM                         AUDIT SYSTEM                             NO
SYSTEM                         UNLIMITED TABLESPACE                     YES

Any help appreciated.
Replies by email preferred James.Dickson_at_mail.esrin.esa.it

Thanks Received on Wed May 22 1996 - 00:00:00 CEST