| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Transportable tablespaces -- yes in 10g ?
Hi!
Not only file headers are affected by big-little endian problem AFAIK, whole contents of files themselves are as well (multibyte char data for example). But in 10g you need RMAN to convert files from one endian format to another.
Tanel.
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!
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_at_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_at_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_at_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_at_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_at_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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: tanel.poder.003_at_mail.ee 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_at_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 Sun Oct 26 2003 - 09:44:24 CST
 |
 |