DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1099708535.632129_at_yasure>...
> djules wrote:
>
> > Is-it possible to transport tablespaces between oracle 8.1.7 and 9.2
> > on unix AIX 5L ?
> > Thanks for answer
>
> No.
Sorry, Daniel, but the answer is yes, as two prior posts attest, one
citing a Metalink quote, repeated here:
"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. "
Says it all, in black and white, from Oracle, no less.
David Fitzjarrell
Received on Sat Nov 06 2004 - 16:48:04 CST