Re: SYSTEM Tablespace is FULL

Pete Finnigan wrote:

>Hi Brian,
>
>You mention moving sys.aud$ to another tablespace, whilst this is common
>sense Oracle no longer support doing this as some poor customer could
>not recover when this had been done. I don't believe Oracle have changed
>advice on this as yet. There is a note on Metalink about it. The
>solution if it is moved is probably to switch audit off whilst
>recovering. Jonathan discussed the following with me some time back:
>
>
>
> <snipped>

Well if we are talking about 9.2 there is no need to audit into sys.aud$ anyway.

The syntax is now:

AUDIT_TRAIL = {NONE | FALSE | DB | TRUE | OS} NONE or FALSE = Audit records are not written. DB or TRUE = Enables system-wide auditing and causes audited records to be written to SYS.AUD$
OS = Enables system-wide auditing and causes audited records to be written to the operating system's audit trail.

And must everything be cross-posted? I've deleted the threads in tools and misc.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)