RE: migrate database

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: 2006-01-12 19:14:45
Message-id: D63E582D09D77648A106C164FC7C483203C3CE8F@mail1-corp.corp.paetec.com

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.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 12 2006 - 19:14:45 CST