Re: Data from 8.1.6 to 10g

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 18 Jan 2005 23:19:40 +0100
Message-ID: <tm2ru056ah3mipt7v6m4rad6ke543rguq2@4ax.com>

On Tue, 18 Jan 2005 23:35:22 +0200, jaak <jaakm_at_hot.ee> wrote:

>Hi,
>
> is it possible to move entire tablespace using Exportable Tablespace
>feature from 8.1.6 database to 10g database ?

No. Identical versions required.

> What if 10g uses different character set (UTF8 )?
transportable tablespace doesn't support characterset conversion.

There is a whitepaper on Metalink on transportable tablespaces outlining this
>Or maybe there is better solution for this.

Traditional export import should work as a charm. Might be not an option for you, bu then you don't post any details about your business case.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jan 18 2005 - 16:19:40 CST