We had the same problem upgrading from 8.1.6 to 9.2.0.
The problem is that you can not upgrade from 8.1.6 but have to install 8.1.7
or 9.0.1, do an upgrade and then install and upgrade to 9.2.0. We decided
to do export/import while converting to locally managed TS with uniform
extents.
Yechiel Ad
Joseph.
I prefer to exp/imp when possible. You get a chance to change anything
you like. With 8.0.5, you may have to upgrade in two steps. You could test
the exp/imp on your test system and get an idea of how much system downtime
your users would experience. Then ask them if that would be accept
We're running Oracle 8.0.5 for 3 years now
and want to go to Oracle9i.
Should I
a) upgrade OR
b) exp the db and do an install of 9i then imp
(this is a lenghty process)
what say you? TIA.
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Leyden, Joseph
INET: [