RE: Moving SYS.AUD$ unsupported?

I understand, but according to my source in support, there is nothing wrong with moving the table.. at least not in earlier versions. My friend is going to do some more digging and get back to me on whether or not you can still move the table.

Rachel

>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 08:05:58 -0800
>
>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
> > (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
Received on Tue Jan 16 2001 - 10:50:38 CST