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. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Thursday, October 23, 2003 6:19 PM Subject: RE: Transportable tablespaces -- yes in 10g ? 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 datafrom one database to another across platforms and database versions. For highest performance, transportabletablespaces move data at the datafile level for fast plug-and-play. Transportable tablespaces can now operate acrossplatforms. Among other things, this allows databases to be migrated to a new platform at the speed of file transfer."HemantAt 11:49 AM 22-10-03 -0800, you wrote: Rachel is in fact correct. See page 4 of the Self Managing Database paperpresented at OracleWorld(https://www.oracleworld2003.com/published/40090/40090.doc).Cloning from one OS to another simply doesn't work because the file headerformats are different between the different OS's. You can't just copy adatafile 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 PorasSent: Thursday, October 23, 2003 2:10 AMTo: Multiple recipients of list ORACLE-LI don't see how this would work. You still have to move the physical datafile to the new machine. What makes a transportable tablespace trasportableis that you notify the data dictionary of the move.If this works, couldn't you just clone from one OS to another by copying dbffiles? Thinking out loud here, a clone would include a few things not intransportable tablespaces: redo logs, control files, rbs tspace, systemtspace. Control files can be rebuilt, redo logs aren't necessary with aclean shutdown (you can recreate the shell. Data doesn't matter). Would thephysical structure of SYSTEM and RBS be that different??? Hmmm...Any thoughts?Henry-Original Message-Rachel CarmichaelSent: Wednesday, October 22, 2003 10:49 AMTo: Multiple recipients of list ORACLE-LI have heard rumors that the 10g tweak on transportable is to allow you tomove cross-platform. Rumors only, I have NO inside information!--- "Goulet, Dick" [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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"
RE: Transportable tablespaces -- yes in 10g ?
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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 --