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:35:11 CST