RE: migrate database
- From: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
- To: <Mark.Bobak@xxxxxxxxxxxxxxx>, <JBECKSTROM@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Wed, 11 Jan 2006 14:37:00 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Bobak, Mark
Sent: Wednesday, January 11, 2006 2:17 PM
To: JBECKSTROM@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
oracle-db-l@xxxxxxxxxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jeffrey Beckstrom
Sent: Wednesday, January 11, 2006 1:52 PM
To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx
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
Other related posts:
