RE: migrate database
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <j.velikanovs@xxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>, <richard.ignizio@xxxxxxxxxx>
- Date: Thu, 12 Jan 2006 13:33:50 -0500
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
Other related posts:
