RE: Moving SYS.AUD$ unsupported?

I think that I have to explain myself more clearly. I had implemented auditory several times. However I had never move the table. I used to copy the records from it with a cron or job to another table in another tbsp.

Regards.

> -----Mensaje original-----
> De: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> Enviado el: martes 16 de enero de 2001 15:25
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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).
>
> _________________________________________________________________
> 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
Received on Tue Jan 16 2001 - 10:03:49 CST