Agreed. But, if you think about how transportable tablespaces work, it doesn't really make sense to transport the SYSTEM tablespace.....I don't think that's a limitation that will change anytime soon....
-- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and those who don't."
__ ____ ____ ____ ____ ____ ____
From: Ignizio, Richard [mailto:richard.ignizio@(protected)] Sent: Wednesday, January 11, 2006 2:37 PM To: Bobak, Mark; JBECKSTROM@(protected); oracle-l@(protected); oracle-db-l@(protected); ORACLE-L@(protected); oracle-rdbms@(protected) Subject: RE: migrate database
I think what he means is that in 10g there is no O/S limitation in regards to using Transporatble tablespaces and one of the limitations is that you cannot transport the system tablespace.
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of Bobak, Mark Sent: Wednesday, January 11, 2006 2:17 PM To: JBECKSTROM@(protected); oracle-l@(protected); oracle-db-l@(protected); ORACLE-L@(protected); oracle-rdbms@(protected) Subject: RE: migrate database
Jeffrey,
I think what you're thinking of, is that starting in 10g, you can migrate a database across platforms via RMAN, avoiding the need for exp/imp.
Not sure what you mean by "migrate the system tablespace". The idea is to migrate the entire database from one platform to another.
-Mark
PS I've not yet tried this, only read about it.....
-- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and those who don't."
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Jeffrey Beckstrom Sent: Wednesday, January 11, 2006 1:52 PM To: oracle-l@(protected); oracle-db-l@(protected); ORACLE-L@(protected); 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD> <BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma"> <DIV dir=ltr align=left><SPAN class=968313919-11012006>Agreed. But, if you think about how transportable tablespaces work, it doesn't really make sense to transport the SYSTEM tablespace.....I don't think that's a limitation that will change anytime soon....</SPAN></DIV> <DIV> </DIV><!-- Converted from text/rtf format --> <P><B><SPAN lang=en-us><FONT face="Century Gothic">--</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT face="Century Gothic">Mark J. Bobak</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT face="Century Gothic">Senior Oracle Architect</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT face="Century Gothic" color=#ff0000>P</FONT><FONT face="Century Gothic">ro</FONT><FONT face="Century Gothic" color=#ff0000>Q</FONT><FONT face="Century Gothic">uest Information & Learning</FONT></SPAN></B> </P> <P><SPAN lang=en-us><FONT face="Californian FB">"There are 10 types of people in the world: Those who understand binary, and those who don't."</FONT></SPAN> </P> <DIV> </DIV><BR> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma><B>From:</B> Ignizio, Richard [mailto:richard.ignizio@(protected)] <BR><B>Sent:</B> Wednesday, January 11, 2006 2:37 PM<BR><B>To:</B> Bobak, Mark; JBECKSTROM@(protected); oracle-l@(protected) ; oracle-db-l@(protected); ORACLE-L@(protected); oracle-rdbms@(protected)<BR><B>Subject:</B> RE: migrate database<BR></FONT><BR></DIV> <DIV></DIV> <DIV><SPAN class=436063119-11012006>I think what he means is that in 10g there is no O/S limitation in regards to using Transporatble tablespaces and one of the limitations is that you cannot transport the system tablespace.</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>Bobak, Mark<BR><B>Sent:</B> Wednesday, January 11, 2006 2:17 PM<BR><B>To:</B> JBECKSTROM@(protected); oracle-l@(protected); oracle-db-l@(protected); ORACLE-L@(protected); oracle-rdbms@(protected)<BR><B>Subject:</B> RE: migrate database<BR><BR></DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006>Jeffrey,</SPAN></DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006>I think what you're thinking of, is that starting in 10g, you can migrate a database across platforms via RMAN, avoiding the need for exp/imp.</SPAN></DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006>Not sure what you mean by "migrate the system tablespace". The idea is to migrate the entire database from one platform to another.</SPAN></DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006>-Mark</SPAN></DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=937161519-11012006>PS I've not yet tried this, only read about it.....</SPAN></DIV> <DIV> </DIV><!-- Converted from text/rtf format --> <P><B><SPAN lang=en-us><FONT face="Century Gothic">--</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT face="Century Gothic">Mark J. Bobak</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT face="Century Gothic">Senior Oracle Architect</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT face="Century Gothic" color=#ff0000>P</FONT><FONT face="Century Gothic">ro</FONT><FONT face="Century Gothic" color=#ff0000>Q</FONT><FONT face="Century Gothic">uest Information & Learning</FONT></SPAN></B> </P> <P><SPAN lang=en-us><FONT face="Californian FB">"There are 10 types of people in the world: Those who understand binary, and those who don't."</FONT></SPAN> </P> <DIV> </DIV><BR> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma><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 1:52 PM<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></FONT><BR></DIV> <DIV></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></BODY></HTML>
