Re: Moving sys.aud$

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 7 Jul 2004 09:51:32 +0100
Message-ID: <40ebb986$0$6442$cc9e4d1f@news-text.dial.pipex.com>

"Michael" <melliott42_at_yahoo.com> wrote in message news:91721cf.0407061727.19c3a2b4_at_posting.google.com...
> Hello,
>
> I have inherited the maintenance of an Oracle 8.17 system with
> Auditing enabled. I have found that the sys.aud$ table is in the
> SYSTEM Tablespace and have been given a directive to move it out of
> SYSTEM. I am thinking that I should move the sys.aud$ table to a
> dedicated tablespace.
>
> 1. How can I move this table to another Tablespace.

See David's reply. If you have created any indexes on aud$ for reporting purposes you'll likely want to move them when you rebuild them as well.

> 2. Are there any special concerns in moving this table and\or auditing
> mechinisms?

Technically Oracle does not support moving aud$ out of the system tablespace - though it details how to do it on Metalink :(.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Wed Jul 07 2004 - 03:51:32 CDT