turning off an object audit

From: EdStevens <quetico_man_at_yahoo.com>
Date: 1 Mar 2007 11:32:31 -0800
Message-ID: <1172777550.900679.145830@31g2000cwt.googlegroups.com>

Oracle 10.2.0.2 on HP-UX

Turned on a bunch of object audits, with statements like

audit all on myuser.HSDASF by session;

The audit statements were genned by selecting on dba_objects where owner='myuser'

That was done at a sqlplus command , but used OEM to turn them off. All turned off except for the 10 audited statements on one particular view. OEM returns 'ORA-04063: view "myuser.GTN0_PER_UPS_PERSON" has errors'.

Any clues what I might have done wrong in genning this in the first place, and how to clean up the mess? Received on Thu Mar 01 2007 - 13:32:31 CST