RE: migrate database

More relevant info from the same link:  

Moving Databases Across Platforms Using Transportable Tablespaces

You can use the transportable tablespace feature to migrate a database to a different \ platform by creating a new database on the destination platform and performing a transport \ of all the user tablespaces. See Oracle Database Backup and Recovery Advanced User's \ Guide for more information.

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. You \ must either create these objects manually on the destination database, or use Data Pump to \ transport the objects that are not moved by transportable tablespace.  

-----Original Message-----

From: Allen, Brandon
Sent: Wednesday, January 11, 2006 12:35 PM To: 'JBECKSTROM_at_gcrta.org'; oracle-l_at_freelists.org Subject: RE: migrate database

Never tried it myself, but found this in the 10gR2 doc( \ http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#i1007252):    

Additional limitations include the following:  

SYSTEM Tablespace Objects You cannot transport the SYSTEM tablespace or objects owned by \ the user SYS. Some examples of such objects are PL/SQL, Java classes, callouts, views, \ synonyms, users, privileges, dimensions, directories, and sequences.  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On \ Behalf Of Jeffrey Beckstrom
Sent: Wednesday, January 11, 2006 11:52 AM To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com; \ ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; oracle-rdbms_at_yahoogroups.com Subject: migrate database

I thought I recalled reading somewhere that in 10G R2 you would be able to even migrate \ the system tablespace across platforms. I am no longer able to find a reference \ supporting this.  

Can you migrate the system tablespace in R2??      

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

Privileged/Confidential Information may be contained in this message or attachments \ hereto. Please advise immediately if you or your employer do not consent to Internet email \ for messages of this kind. Opinions, conclusions and other information in this message \ that do not relate to the official business of this company shall be understood as neither \ given nor endorsed by it. Received on Wed Jan 11 2006 - 20:39:52 CST