Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrate database

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US