Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrate database

RE: migrate database

From: Allen, Brandon <>
Date: 2006-01-11 20:39:52
Message-id: 04DDF147ED3A0D42B48A48A18D574C4503D40066@NT15.oneneck.corp

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: ''; Subject: RE: migrate database

Never tried it myself, but found this in the 10gR2 doc( \    

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: []On \ Behalf Of Jeffrey Beckstrom
Sent: Wednesday, January 11, 2006 11:52 AM To:;; \ ORACLE-L_at_IC.SUNYSB.EDU;; 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

Original text of this message