Re: turning off an object audit

On Mar 1, 2:32 pm, "EdStevens" <quetico_..._at_yahoo.com> wrote:
> 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?

My first guess is that perhaps you should believe the oracle message and that perhaps there are problems with that view.

Dropping the view is one possible solution.

Are you really an oracle dba? Received on Thu Mar 01 2007 - 15:42:52 CST