RE: Moving SYS.AUD$ unsupported?

the data is IN the table.... or is there a new feature of Oracle that allows you to have a table in one tablespace and the data within that table in another tablespace that I hadn't heard of?

I was at a site where we enabled auditing and did not move sys.aud$

System tablespace filled and the database froze.

Move the table. Or be very very careful of what auditing you enable and monitor the hell out of it to make sure you are not eating up the system tablespace space and not fragmenting it. 'Cause if you do that, well, you either add another datafile or rebuild the database.

I suppose you could just leave aud$ in the system tablespace and then archive off the old data into a different table in a different tablespace and then purge aud$ but that seems a bit convoluted to me.

>From: "Trassens, Christian" <CTrassens_at_uni2.es>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Moving SYS.AUD$ unsupported?
>Date: Tue, 16 Jan 2001 02:40:25 -0800
>
>Rachel,
>
>I never wondered about moving the table, only the data.
>
>Regards.
>
> > -----Mensaje original-----
> > De: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> > Enviado el: martes 16 de enero de 2001 11:11
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: RE: Moving SYS.AUD$ unsupported?
> >
> > in prior releases of Oracle, Support recommended that AUD$ be moved out
>of
> >
> > the system tablespace. It was the ONLY table they sanctioned moving.
> >
> >
> >
> >
> > >From: "Trassens, Christian" <CTrassens_at_uni2.es>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: RE: Moving SYS.AUD$ unsupported?
> > >Date: Tue, 16 Jan 2001 00:25:53 -0800
> > >
> > >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).
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
Received on Tue Jan 16 2001 - 08:26:17 CST