"djules" <djules_at_gaz-de-bordeaux.com> wrote in message
news:1225f3bb.0411040452.49c2e52d_at_posting.google.com...
> Is-it possible to transport tablespaces between oracle 8.1.7 and 9.2
> on unix AIX 5L ?
> Thanks for answer
This is from Metalink :
"Compatibility Considerations for Transportable Tablespaces
To use the transportable tablespaces feature, the COMPATIBLE initialization
parameter for both the source and target databases must be set to 8.1 or
higher. If the block size of any tablespace being transported is different
from the standard block size for the target database, the COMPATIBLE
initialization parameter must be
set to 9.0 or higher for the target database. You are not required to be
running the same release of Oracle for both the source and target database.
Oracle guarantees that the transportable tablespace set is compatible with
the target database. If not, an error is signaled at the beginning of the
plug-in operation. It is always possible to transport a tablespace from a
database running an older
release of Oracle (starting with Oracle8i) to a database running a newer
release of Oracle (for example, Oracle9i). When creating a transportable
tablespace set, Oracle computes the lowest compatibility level at which the
target database must run. This is referred to as the compatibility level of
the transportable set. When plugging the transportable set into a target
database, Oracle signals an error if the compatibility level of the
transportable set is greater than the compatibility level of the target
database. "
HTH,
Matthias Hoys
Received on Thu Nov 04 2004 - 14:19:35 CST