RE: migrate database
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>, <JBECKSTROM@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Wed, 11 Jan 2006 14:40:33 -0500
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@xxxxxxxxxx]
Sent: Wednesday, January 11, 2006 2:37 PM
To: Bobak, Mark; JBECKSTROM@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
oracle-db-l@xxxxxxxxxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
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@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
BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD
Other related posts:
