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 <http://download-west .oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm#BRADV05432> 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.
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@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of Jeffrey Beckstrom Sent: Wednesday, January 11, 2006 11:52 AM To: oracle-l@(protected); oracle-db-l@(protected); ORACLE-L@(protected) .SUNYSB.EDU; oracledba@(protected); oracle-rdbms@(protected) 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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1528" name=GENERATOR></HEAD> <BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma"> <DIV><SPAN class=809213919-11012006>More relevant info from the same link:</SPAN></DIV> <DIV><SPAN class=809213919-11012006></SPAN> </DIV> <DIV><SPAN class=809213919-11012006> <H3>Moving Databases Across Platforms Using Transportable Tablespaces</H3> <P>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 <A class="xlinkSRC BRADV05432" href="http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191 /dbxptrn.htm#BRADV05432"><SPAN class=italic>Oracle Database Backup and Recovery Advanced User's Guide</SPAN></A> for more information.</P> <P>You cannot transport the <CODE>SYSTEM</CODE> tablespace. Therefore, objects such as sequences, PL/SQL packages, and other objects that depend on the <CODE>SYSTEM</CODE> 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.</P> <P> </P></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left>-- --Original Message-- --<BR><B>From:</B> Allen, Brandon <BR><B>Sent:</B> Wednesday, January 11, 2006 12:35 PM<BR><B>To:</B> 'JBECKSTROM@(protected)'; oracle-l@(protected)<BR><B>Subject:</B> RE: migrate database<BR><BR></DIV> <DIV><SPAN class=905472919-11012006>Never tried it myself, but found this in the 10gR2 doc(<A href="http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231 /tspaces.htm#i1007252">http://download-west.oracle.com/docs/cd/B19306_01/server .102/b14231/tspaces.htm#i1007252</A>):</SPAN></DIV> <DIV><SPAN class=905472919-11012006></SPAN> </DIV> <DIV><SPAN class=905472919-11012006></SPAN> </DIV> <DIV><SPAN class=905472919-11012006>Additional limitations include the following:</SPAN></DIV> <DIV><SPAN class=905472919-11012006></SPAN> </DIV> <DIV><SPAN class=905472919-11012006><SPAN class=subhead3>SYSTEM Tablespace Objects </SPAN>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.</SPAN></DIV> <DIV><SPAN class=905472919-11012006></SPAN> </DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left>-- --Original Message-- --<BR><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]<B>On Behalf Of </B>Jeffrey Beckstrom<BR><B>Sent:</B> Wednesday, January 11, 2006 11:52 AM<BR><B>To:</B > oracle-l@(protected); oracle-db-l@(protected); ORACLE-L@(protected); oracledba@(protected); oracle-rdbms@(protected)<BR><B>Subject:</B> migrate database<BR><BR></DIV> <DIV>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.</DIV> <DIV> </DIV> <DIV>Can you migrate the system tablespace in R2??</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland Regional Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113</DIV></BLOCKQUOTE></BLOCKQUOTE></BODY><!--[object_id=#oneneck.com#]-- ><FONT face=Tahoma size=2><FONT color=#0000ff> <P>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.</P>< /FONT></FONT></HTML>
