Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id hBCJvdI20575 for ; Fri, 12 Dec 2003 13:57:39 -0600 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id hBCJvco20568 for ; Fri, 12 Dec 2003 13:57:39 -0600 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id hBCJqkc27074 for oracle-l@orafaq.com; Fri, 12 Dec 2003 11:52:46 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D9B34; Fri, 12 Dec 2003 11:54:27 -0800 Message-ID: Date: Fri, 12 Dec 2003 11:54:27 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Subject: RE: for security patches - going to 9.2.0.4 Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3C0E9.D61720C0" ------_=_NextPart_001_01C3C0E9.D61720C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

That=20 is the case. I do have tablespaces that are locally managed - I = did the=20 migrate with compatible set to 8.1.7. I did startup the = database. =20 However, my system tablespace is dictionary managed - all others are = not. =20

The=20 migration worked. I have large databases and have been using = Oracle's=20 migration utility from 7 - 8 and 8 - 9. Yes, it is quirky and = tricky but=20 better than export/import on large databases.

-----Original Message-----
From: = ml-errors@fatcity.com=20 [mailto:ml-errors@fatcity.com]On Behalf Of Paul = Drake
Sent:=20 Thursday, December 11, 2003 7:04 PM
To: Multiple recipients = of list=20 ORACLE-L
Subject: RE: for security patches - going to=20 9.2.0.4

Paula,

I hope that you are just confused.

AFAIK, if you have created a database with a locally managed = system=20 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=20 you won't have a database instance to attach to. But this might be a = myth of=20 mine, its awhile since I last read the upgrade/migration guide.

I can see setting the init.ora parameter

optimizer_features_enable =3D 8.1.7

if the 9.2 CBO acts quite differently from its older brother did, = back in=20 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=20 still dictionary managed - that is a completely different=20 matter.

I've been lucky enough that most dbs were small enough to just = use=20 exp/imp and move data into a clean, newly created db.

Paul

Paula_Stankus@doh.state.fl.us = wrote:

Guys,

I=20 saved all of your writing including Todd Boxx, Richard Foote, = Wolfgang...=20 about issues with 9.2.0.4. We are currently on 9.2.0.3 and I = understand=20 (although have not hit it yet) that in this version we could get = locks when=20 building indexes. Also, that basically you need to set your = compatible=20 parameter to 8.1.7. On some databases we have compatible set to = 9.2.0.0.=20

Question:

-any bugs/problems going to 9.2.0.4=20 and...
-should we really change compatible from 9.X to=20 8.1.7?????

We are currently migrating a large database to 9.X = and I=20 want to know if I should use the latest patchset 9.2.0.4 - for = security and=20 performance reasons?

Also, we have some dev/test databases = where once=20 they go into production performance could be an issue - should we = change the=20 compatible param. to 8.1.7 = proactively????

Thanks,
Paula
--=20
Please! see the official ORACLE-L FAQ: = http://www.orafaq.net
--=20
Author: INET:=20 Paula_Stankus@doh.state.fl.us

Fat City Network Services --=20 858-538-5051 http://www.fatcity.com
San Diego, California -- = Mailing list=20 and web hosting=20 = services
-------------------------------------------------------------= --------
To=20 REMOVE yourself from this mailing list, send an E-Mail = message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and = in
the=20 message BODY, include a line containing: UNSUB ORACLE-L
(or the = name of=20 mailing list you want to be removed from). You may
also send the = HELP=20 command for other information (like subscribing).

Do you Yahoo!?
New=20 Yahoo! Photos - easier uploading and = sharing

------_=_NextPart_001_01C3C0E9.D61720C0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: