RE: migrate database

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: 2006-01-12 19:47:29
Message-id: D63E582D09D77648A106C164FC7C483203C3CE92@mail1-corp.corp.paetec.com

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:47:29 CST