Re: migrate database

From: Yechiel Adar <adar76_at_inter.net.il>
Date: 2006-01-12 20:00:05
Message-id: 43C6A735.8040304@inter.net.il

The replies I saw are mixing two concepts: 1) Using RMAN to copy a DATABASE to new platform, which copy the whole database, including system tablespace.
2) Using transportable tablespace to move TABLESPACE to a new database on another platform.

I do not know much about RMAN so I will not touch this topic. Transportable tablespace is:

1) Exporting the metadata that describe the objects in the tablespace.
2) Moving the tablespace to the new location.
3) Running import tablespace that merge the objects metadata into an 

existing database.

Since the import works against existing database, and this database already have SYSTEM tablespace, you can not do transportable tablespace for system.

Adar Yechiel
Rechovot, Israel

Ignizio, Richard wrote:

>When using Transportable tablespaces you cannot export the SYSTEM tablespace(but you can \
export the undo tablespace):
>
>exec sys.dbms_tts.transport_set_check('SYSTEM');
>BEGIN sys.dbms_tts.transport_set_check('SYSTEM'); END;
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 12 2006 - 20:00:05 CST