]
[mailto:[EMAIL PROTECTED] Behalf Of *Paul Drake
*Sent:* Friday, December 12, 2003 4:49 PM
*To:* Multiple recipients of list ORACLE-L
*Subject:* RE: for security patches - going to 9.2.0.4
Paula,
since you use the export utility - patch
Title: RE: for security patches - going to 9.2.0.4
Paula,
I had also bad experience when we upgraded one of our applications from 8.1.7 to 9.2.0.1 There were some queries that executed significantly slower then on 8.1.7. What we have done was:
1. We gathered system statistics
Title: RE: for security patches - going to 9.2.0.4
Thanks
so much. This was very well explained and I appreciate the time you took
to share it. I will go through the Metalink and read this over and
test.
Thanks
Again,
Paula
-Original Message-From: [EMAIL PROTECTED]
[mailto
of list
ORACLE-LSubject: RE: for security patches - going to
9.2.0.4
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
of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4
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
-LSubject: RE: for security patches - going to
9.2.0.4
Paula,
since you use the export utility - patch to 9.2.0.4.
a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0.
regarding security, I haven't yet applied the 8.1.7.4.13 patchset (its
not yet available) or the SSL
, December 12, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: for security patches - going to 9.2.0.4
Paula,
since you use the export utility - patch to 9.2.0.4.
a full export will throw an error in 9.2.0.3, on W2K and on RH 8.0.
regarding security, I haven't yet applied
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
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