Re: Move sys.aud$ -- response

fitzjarrell_at_cox.net (David Fitzjarrell) wrote in message news:<9711ade0.0407061753.4b5f0d48_at_posting.google.com>...
> on 07/06/2004, at 8:27 PM CDT, Michael wrote:
> > 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.
> > 2. Are there any special concerns in moving this table and\or auditing
> > mechinisms?
> >
> > Thanks for your advice,
> >
> > Cal
>
> Do this:
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> create tablespace audit_tbs datafile '.....' size 500M reuse;
>
> Tablespace created.
>
> SVRMGR> alter table aud$ move tablespace audit_tbs;
>
> Table altered.
>
> SVRMGR> exit
>
> As long as you maintain the SYS ownership of AUD$ you'll be fine, and
> connect internal in 8.1.7 does just that. Remember to substitute a
> valid path and filename for the '.....' in the create tablespace
> command.
>
> David Fitzjarrell

Oracle had a white paper on this topic. In the paper support provides the steps for moving the aud$ but then tells you that the operation is unsupported and Oracle does not guarentee that everything will work correctly after upgrades. See Note:72460.1 revision of 30-Mar-2003.

If you move the table you should probably also move the index: I_AUD1.

HTH -- Mark D Powell -- Received on Wed Jul 07 2004 - 08:38:08 CDT