Paula,
I hope that you are just confused.
AFAIK, if you have created a database with a locally managed system
tablespace, that you cannot set compatible to anything lower than
9.0.1.
Ok, you can set it, but oracle will complain during instance startup
and you won't have a database instance to attach to. But this might be a
myth of mine, its awhile since I last read the upgrade/migration
guide.
I can see setting the init.ora parameter
optimizer_features_enable = 8.1.7
if the 9.2 CBO acts quite differently from its older brother did,
back in 8.1.7.
But compatible? I seriously doubt it.
If you migrated your db from 8.1.7 to 9.2 and the system tablespace
is still dictionary managed - that is a completely different
matter.
I've been lucky enough that most dbs were small enough to just use
exp/imp and move data into a clean, newly created db.
Paul
Paula_Stankus@doh.state.fl.us
wrote:
Guys,
I
saved all of your writing including Todd Boxx, Richard Foote,
Wolfgang... about issues with 9.2.0.4. We are currently on 9.2.0.3 and I
understand (although have not hit it yet) that in this version we could
get locks when building indexes. Also, that basically you need to set
your compatible parameter to 8.1.7. On some databases we have compatible
set to 9.2.0.0.
Question:
-any bugs/problems going to
9.2.0.4 and...
-should we really change compatible from 9.X to
8.1.7?????
We are currently migrating a large database to 9.X and
I want to know if I should use the latest patchset 9.2.0.4 - for
security and performance reasons?
Also, we have some dev/test
databases where once they go into production performance could be an
issue - should we change the compatible param. to 8.1.7
proactively????
Thanks,
Paula
--
Please! ! see the
official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET:
Paula_Stankus@doh.state.fl.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@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
Yahoo! Photos - easier uploading and sharing
