Hmm.
Quoting Page 2 of
http://otn.oracle.com/products/database/oracle10g/pdf/OW_General_OracleDatabase10G_Revolution_10R1_081903.pdf
"
To assist in migrating to Enterprise
Grid Computing, Oracle Database
10g
enables very high-speed movement
of data
from one database to another across platforms and database versions. For
highest performance, transportable
tablespaces move data at the datafile level for fast “plug-and-play”.
Transportable tablespaces can now operate across
platforms. Among other things, this allows databases to be migrated to a
new platform at the speed of file
transfer."
Hemant
At 11:49 AM 22-10-03 -0800, you wrote:
Rachel is in fact correct.
See page 4 of the Self Managing Database paper
presented at OracleWorld
(https://www.oracleworld2003.com/published/40090/40090.doc).
Cloning from one OS to another simply doesn't work because the file
header
formats are different between the different OS's. You can't just
copy a
datafile from Linux to Solaris, for example, and expect to read
it.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
Henry Poras
Sent: Thursday, October 23, 2003 2:10 AM
To: Multiple recipients of list ORACLE-L
I don't see how this would work. You still have to move the physical
data
file to the new machine. What makes a transportable tablespace
trasportable
is that you notify the data dictionary of the move.
If this works, couldn't you just clone from one OS to another by copying
dbf
files? Thinking out loud here, a clone would include a few things not
in
transportable tablespaces: redo logs, control files, rbs tspace,
system
tspace. Control files can be rebuilt, redo logs aren't necessary with
a
clean shutdown (you can recreate the shell. Data doesn't matter). Would
the
physical structure of SYSTEM and RBS be that different???
Hmmm...
Any thoughts?
Henry
-----Original Message-----
Rachel Carmichael
Sent: Wednesday, October 22, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
I have heard rumors that the 10g tweak on transportable is to allow you
to
move cross-platform. Rumors only, I have NO inside information!
--- "Goulet, Dick" <DGoulet@vicr.com> wrote:
> Humm, That's interesting. Transportable tablespaces were
introduced
> in 8i, 9i allowed us to have multiple block sizes at the tablespace
> level for flexibility. But I've not heard that one can
transport a
> tablespace/datafile across platforms. What a wonderful way to
trash
> all of those Windoze servers out there for Linux!!
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Tuesday, October 21, 2003 9:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Listers
>
> Saw this on SearchOracle
> What new features are customers excited about in 10G?
> Abramson: What they've done is given you complete flexibility. They
> have introduced transportable table spaces, so all you have to do
is
> export
> metadata and just copy files across during an upgrade. You don't
have
> to
> do a full extraction. I've been in a situation were a company was
on
> Sun
> and moving to HP, and they wanted to know how to do it. I told
them
> that
> you just unload the database and reload the database. It sounds
easy,
> but
> with two terabytes of data it's not unless you have
transportable
> table
> spaces.
>
> Can anyone confirm that this is true, that is, the implication that
I
> can copy a transportable tablespace from Sun to HP or vice versa
> without issue. I suppose then is it big endian - little endian
> constrained or not
>
> Cheers
>
>
> --
> =================================================
> Peter
McLarty
E-mail: Peter.Mclarty@mincom.com
> Technical Consultant WWW:
http://www.mincom.com
> APAC Technical Services Phone: +61 (0)7 3303
3461
> Brisbane, Australia
Mobile: +61 (0)402 094 238
>
Facsimile: +61 (0)7 3303 3048
> =================================================
> "If people did not sometimes do silly things, nothing
intelligent
> would ever
> get done."
> - Ludwig Wittgenstein
> =================================================
> Mincom "The People, The Experience, The Vision"
>
> =================================================
>
> This transmission is for the intended addressee only and is
> confidential information. If you have received this transmission in
> error, please delete it and notify the sender. The contents of this
> e-mail are the opinion of the writer only and are not endorsed by
the
> Mincom Group of
> companies unless expressly stated otherwise.
>
>
>
>
> --
> This transmission is for the intended addressee only and is
> confidential information. If you have received this transmission in
> error, please notify the sender and delete the transmission. The
> contents of this e-mail are the opinion of the writer only and are
not
> endorsed by the Mincom Group of companies unless expressly stated
> otherwise.
>
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.net
> --
> Author:
> INET: Peter.McLarty@mincom.com
>
> Fat City Network Services -- 858-538-5051
http://www.fatcity.com
> San Diego, California --
Mailing list and web hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may
also send
> the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.net
> --
> Author: Goulet, Dick
> INET: DGoulet@vicr.com
>
> Fat City Network Services -- 858-538-5051
http://www.fatcity.com
> San Diego, California --
Mailing list and web hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may
also send
> the HELP command for other information (like subscribing).
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100@yahoo.com
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the
message BODY, include a line containing: UNSUB ORACLE-L (or the name
of
mailing list you want to be removed from). You may also send the
HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Henry Poras
INET: hporas@etal.uri.edu
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the
message BODY, include a line containing: UNSUB ORACLE-L (or the name
of
mailing list you want to be removed from). You may also send the
HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Pete Sharman
INET: peter.sharman@oracle.com
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California --
Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: hkchital@singnet.com.sg
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 23 2003 - 11:19:26 CDT
