Would this convert the system tablespace as well? >>> "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx> 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@xxxxxxxxx] Sent: Thursday, January 12, 2006 1:34 PM To: j.velikanovs@xxxxxxxxx; Brandon.Allen@xxxxxxxxxxx; Ignizio, Richard Cc: oracle-l@xxxxxxxxxxxxx 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" <richard.ignizio@xxxxxxxxxx> 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' <==========@!!!!!!!!! ORA-06512: at "SYS.DBMS_TTS", line 818 ORA-06512: at line 1 From Metalink note 71473.1: Oracle 9.2 or Earlier Error Message ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: ORA-29351 Text: can not transport system or temporary tablespace '%s' --------------------------------------------------------------------------- Cause: The referred tablespace is either the system tablespace or a temporary tablespace. Action: Do not include this tablespace in the transportable set. Rich -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jurijs Velikanovs Sent: Thursday, January 12, 2006 12:57 PM To: Brandon.Allen@xxxxxxxxxxx Cc: JBECKSTROM@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: migrate database > 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. -- //www.freelists.org/webpage/oracle-l