RE: migrate database

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: 2006-01-12 19:58:05
Message-id: s3c66073.089@gcrta.org

Would this convert the system tablespace as well?

>>> "Ignizio, Richard" 1/12/06 1:47:29 PM >>>
CONVERT DATABASE is used when the endian format between the two databases are different and you convert the datafiles to the endian format of the database you are migrating to.  

Rich
-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Thursday, January 12, 2006 1:34 PM To: j.velikanovs_at_gmail.com; Brandon.Allen_at_oneneck.com; Ignizio, Richard
Cc: oracle-l_at_freelists.org
Subject: RE: migrate database

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:58:05 CST