RE: migrate database

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: 2006-01-12 19:33:50
Message-id: s3c65adf.063@gcrta.org

Then what does the RMAN "Convert database" command do?  

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

>>> "Ignizio, Richard" 1/12/06 1:14:45 PM >>>

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;

*
ERROR at line 1:

ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_SYS_SQL", line 819
ORA-06512: at "SYS.DBMS_SQL", line 19
ORA-06512: at "SYS.DBMS_TTS", line 789
ORA-29351: can not transport system or temporary tablespace 'SYSTEM' 

 You cannot transport the SYSTEM tablespace. Therefore, objects such as
> sequences, PL/SQL packages, and other objects that depend on the
SYSTEM
> tablespace are not transported.

The statement above not true for the same endian format platforms. You can easily transport SYSTEM tablespace (+UNDO) from Win to Linux for example. However you unable to do that between SPARC Solaris & Linux.

J.

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

Received on Thu Jan 12 2006 - 19:33:50 CST