RE: Moving SYS.AUD$ unsupported?

Can you please send me the procedure. I promise I won't try to move sys.aud$!! But just out of curiosity I wanted to know how to do it. Whether just alter table sys.aud$.... tablespace xyz; will move the table? How to know which audit views are to be compiled then? and How to compile those.

Thanks in Advance,
Hitarth :) OCP DBA 7.3

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Tuesday, January 16, 2001 3:40 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Moving SYS.AUD$ unsupported?

i have done this MANY times... !! on 7.3 and then on 8.1.5 the procedure is very simple and without any bugs... remember to compile all the audit views after you move the table.

Rahul

> ----------
> From: Trassens, Christian[SMTP:CTrassens_at_uni2.es]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, January 16, 2001 3:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Moving SYS.AUD$ unsupported?
>
> Steve,
>
> You should never move any table of the dictionary in any release. And that
> includes sys.aud$. However and maybe you are confused with those
> procedures
> or scripts that keeps the data of sys.aud$ off the system tbsp.
>
> Regards.
>
> > -----Mensaje original-----
> > De: Steve Orr [SMTP:sorr_at_arzoo.com ]
> > Enviado el: martes 16 de enero de 2001 3:05
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Moving SYS.AUD$ unsupported?
> >
> > I'm getting ready to set up some auditing and in the past I've routinely
> > moved the SYS.AUD$ out of the system tablespace thinking it was the only
> > data dictionary table move supported by Oracle. But I just stumbled on
> the
> > following in the 8.1.6 Admin manual:
> >
> > "Note: Moving the SYS.AUD$ table out of the SYSTEM tablespace
> > is not supported because the Oracle code makes implicit
> > assumptions about the data dictionary tables such as SYS.AUD$,
> > which could cause problems with upgrades and backup/recovery
> > scenarios."
> >
> > Is this a documentation change reflecting a new Oracle policy? Does
> anyone
> > know why Oracle made this change? What would be the ramifications of
> > moving
> > the table?
> >
> > Steve Orr
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Steve Orr
> > INET: sorr_at_arzoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Trassens, Christian
> INET: CTrassens_at_uni2.es
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may