and the latest I have heard is that they no longer will support moving
AUD$. Even though it's listed on MetaLink
- Inka Bezdziecka <IBezdziecka_at_cupe.ca> 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
> Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex,
> WI USA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> 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: 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: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> 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: 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: Inka Bezdziecka
> INET: IBezdziecka_at_cupe.ca
>
> 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: 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).
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: wisernet100_at_yahoo.com
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: 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 Oct 01 2002 - 13:48:36 CDT