Message-Id: <10743.126789@fatcity.com> From: "Trassens, Christian" Date: Tue, 16 Jan 2001 17:03:49 +0100 Subject: 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@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" > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >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@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" > > > >Reply-To: ORACLE-L@fatcity.com > > > >To: Multiple recipients of list ORACLE-L > > > >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@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@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@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@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@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@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@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@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@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@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@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L