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
Here's
the script that I use to get the session the current SQL
statement:
define
sid = 1column client_info format A30 trunccolumn program format A40
truncbreak on sql_address on sql_hash_valuecolumn sql_address noprint
new_value _addrcolumn sql_hash_value noprint new_value _hashset
I partially agree with Mladen.
RMAN definitely doesn't identify Table HWMs -- it doesn't know logical
structures such as Tables and Segments and Tablespaces [although it
can assist you in Tablespace Recovery when it reads the Data Dictionary].
RMAN knows physical structures such as DataFiles,