David Fitzjarrell wrote:
> 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
You are correct. I was thinking 9i back to 8i and thinking LMT vs
Dictionary managed. Both of which are not necessarily issues here.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Nov 07 2004 - 15:00:32 CST
