and the latest I have heard is that they no longer will support moving AUD$. Even though it's listed on MetaLink
--- Inka Bezdziecka <[EMAIL PROTECTED]> wrote: > Oracle Corporation has a peculiar habit of providing scripts and > solutions which it does not support officially. One of them is > moving sys.aud$ out of SYSTEM tablespace. See note 1019377.6 on > MetaLink. > > inka > > -----Original Message----- > Sent: Tuesday, October 01, 2002 1:18 PM > To: Multiple recipients of list ORACLE-L > > > Rich, > > I think you're crazy adding indexes SYS tables. I would *never* add > anything to sys objects. What are you going to do the first time > something > goes wrong and you call Oracle support and you "mention" you added an > index > and they say - hey, you're on your own! Not to mention that when you > perform an upgrade, that this index may either get lost or be in the > way. > > No, a totally bad idea. > > If anything, I would copy the audit records to a local table in your > schema, > and then index that baby anyway I'd like. That way, the system > objects are > the way that Oracle inteneded them to be. > > Just my 2 cents. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Tuesday, October 01, 2002 11:28 AM > To: Multiple recipients of list ORACLE-L > > > Hey, > > Anyone have any advice on indexing SYS tables? Specifically, I've > been > experimenting with putting a reverse index on the TIMESTAMP# column > of AUD$, > since almost all of my queries against the AUD$ views end with "ORDER > BY > TIMESTAMP DESC". > > In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS > DBA > schema -- works great. I'm looking for pitfalls, but can't come up > with any > of my own... > > TIA! > Rich > > -- > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, > WI USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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: Inka Bezdziecka > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).