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
RE: Transportable tablespaces
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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Transportable tablespaces
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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: Transportable tablespaces
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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: Transportable tablespaces
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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: Transportable tablespaces
Pete, I remember trying to read an 8.1.7.3 database on w2k (ntfs)from a Suse Linux 7.1 install (dual boot). In theory, it was supposed to work. In practice, it hanged the system. Rachel, someday, I'll get LILO on that box to default into windows so that you don't have to catch it during bootup. But replacing the box is always an option :D. PaulPete Sharman [EMAIL PROTECTED] 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 trasportab! leis 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 s! ometimes 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 t! he 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: [EMAIL PROTECTED] 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
RE: Transportable tablespaces
Pete, Thanks for the reference. I'm still a bit confused, however. If you can't just copy a datafile between OS's because of the differences in the file header formats, why can you copy datafiles between OS's when done as a transportable tablespace? Henry -Original Message- Pete Sharman Sent: Wednesday, October 22, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Transportable tablespaces
I didn't say you wouldn't have to export the metadata, as you do in 8i and 9i --- Henry Poras [EMAIL PROTECTED] wrote: 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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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
RE: Transportable tablespaces
It's because there's more magic behind the scenes that does things like the little endian big endian conversion. It's not transparent as you would need it to be for a straight copy at the OS level to work. 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 6:29 AM To: Multiple recipients of list ORACLE-L Pete, Thanks for the reference. I'm still a bit confused, however. If you can't just copy a datafile between OS's because of the differences in the file header formats, why can you copy datafiles between OS's when done as a transportable tablespace? Henry -Original Message- Pete Sharman Sent: Wednesday, October 22, 2003 3:49 PM To: Multiple recipients of list ORACLE-L 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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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
RE: Transportable tablespaces
but exporting the metadata just adds the necessary information to the data dictionary. It doesn't touch the data file headers (or does it???). Henry -Original Message- Rachel Carmichael Sent: Wednesday, October 22, 2003 3:25 PM To: Multiple recipients of list ORACLE-L I didn't say you wouldn't have to export the metadata, as you do in 8i and 9i --- Henry Poras [EMAIL PROTECTED] wrote: 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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED
Re: Transportable tablespaces
People here are bound by non-disclosure agreements, even if they've seen 10g, which most of us have not. Don't despair, I know a guy who can help you. His name is Tom Kyte and he can be contacted at http://asktom.oracle.com. Tell him that Mladen sent you and everything will be OK. On 2003.10.21 21:39, [EMAIL PROTECTED] wrote: 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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Transportable tablespaces
have they added the ability to rename tablespaces? this way you can publish data easier? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 9:39 PM 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 ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Transportable Tablespaces
Anyone got a "1, 2, 3" for using transportable tablespaces? Got a client that thinks this might be a good solution to transfer large amounts of data. This is HP/UX and should be 8.1.7.4... Any gotchas that may kill this idea? Thanks. Michael Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond, VA804-744-1545
RE: Transportable Tablespaces
Title: Message You can reference the documentation at http://tinyurl.com/qhcl paying specific attention to the "Limitations". MetaLink documents 100693.1 and 77523.1 provide some helpful information as well. -Original Message-From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 3:14 PMTo: Multiple recipients of list ORACLE-LSubject: Transportable Tablespaces Anyone got a "1, 2, 3" for using transportable tablespaces? Got a client that thinks this might be a good solution to transfer large amounts of data. This is HP/UX and should be 8.1.7.4... Any gotchas that may kill this idea? Thanks. Michael Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond, VA804-744-1545
RE: Transportable Tablespaces
Title: Message Just be aware of an undocumented "feature" in 8i (8.1.7.2 for me). Once you transport a tablespace from DB-A to DB-B, you can't transport (the same TS) from DB-B to DB-C. There are some internal issues preventing the re-transport. I believe this is fixed in 9i. Regards, Alan Martin DBA - Defense Logistics Info Service -Original Message-From: Rothouse, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 3:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Transportable Tablespaces You can reference the documentation at http://tinyurl.com/qhcl paying specific attention to the "Limitations". MetaLink documents 100693.1 and 77523.1 provide some helpful information as well. -Original Message-From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 3:14 PMTo: Multiple recipients of list ORACLE-LSubject: Transportable Tablespaces Anyone got a "1, 2, 3" for using transportable tablespaces? Got a client that thinks this might be a good solution to transfer large amounts of data. This is HP/UX and should be 8.1.7.4... Any gotchas that may kill this idea? Thanks. Michael Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond, VA804-744-1545
RE: Transportable Tablespaces as backup?
Kirti, Jonathan - Thanks for your responses. I was able to validate the process with a small test tablespace. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 18, 2002 8:34 PM To: Multiple recipients of list ORACLE-L I did that once. And did not run into any problems. HP-UX 11.0 Oracle 8.1.7.4. Worked rather well to my surprise. Never thought that TTS could be so useful! For me, the time consuming part was altering the source TBS to read-only mode as the database was rather busy at the time. We also had two databases on the same server share one datafile! Both using it in read-only mode. TTS is a neat thing :) - Kirti -Original Message- Sent: Wednesday, December 18, 2002 3:26 PM To: Multiple recipients of list ORACLE-L Someone asked the same question at one of my seminars recently, and I couldn't think of a good reason why - for THEIR circumstances - it would be a bad idea. Of course you do have to drop the messed tablespace including contents - which can be quite time-consuming, especially with DMTs and/or tablespace quotas - but if the tablespaces are truly 100% independent of the rest of the database it sounds okay. The only thing I would test (other than a check to see that it seems to work) is whether there is some strange overhead in latching that takes place anywhere because the tablespaces are 'known' to be alien pluggable tablespaces. I believe that the x$bh flag has a special bit set to show that the blocks didn't come from the original database - I don't know if this causes any extra codepath to be used. (It might actually shorten it, of course, as Oracle would know that any block in that tablespace couldn't possibly need any local work done for read consistency). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 December 2002 21:15 Has anyone used transportable tablespaces as a special backup method? Periodically I get a request from our applications people to backup these tables before we run this year-end program so if something goes wrong we can reset everything. And the attention-getter is if we can't recover, you won't get paid again. - Usually nothing goes wrong (thankfully). - We do full backups, obviously, but there are unpleasant consequences for rolling back an enterprise-scale database. The system goes back for everyone. Obviously we can do a TSPITR over on a test system, but I don't like to rely on that alone. - Export works great for small to medium size tables. - Export of large tables is fine, but my experience says that importing a really large table can take a LOOONG time, a frightening prospect during an emergency. - It occurs to me that making the tablespace read-only and performing a transportable export should work great. These large tables are in their own tablespace. The application doesn't any RI in Oracle. - Recovery should be a matter of dropping the existing tablespace, copying the backup datafile off tape, running the import procedure, and making the tablespace read-write. Much faster than the true import. Am I missing something? I plan to try this on a test system to make sure I have the right syntax. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Transportable Tablespaces as backup?
Has anyone used transportable tablespaces as a special backup method? Periodically I get a request from our applications people to backup these tables before we run this year-end program so if something goes wrong we can reset everything. And the attention-getter is if we can't recover, you won't get paid again. - Usually nothing goes wrong (thankfully). - We do full backups, obviously, but there are unpleasant consequences for rolling back an enterprise-scale database. The system goes back for everyone. Obviously we can do a TSPITR over on a test system, but I don't like to rely on that alone. - Export works great for small to medium size tables. - Export of large tables is fine, but my experience says that importing a really large table can take a LOOONG time, a frightening prospect during an emergency. - It occurs to me that making the tablespace read-only and performing a transportable export should work great. These large tables are in their own tablespace. The application doesn't any RI in Oracle. - Recovery should be a matter of dropping the existing tablespace, copying the backup datafile off tape, running the import procedure, and making the tablespace read-write. Much faster than the true import. Am I missing something? I plan to try this on a test system to make sure I have the right syntax. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Transportable Tablespaces as backup?
Someone asked the same question at one of my seminars recently, and I couldn't think of a good reason why - for THEIR circumstances - it would be a bad idea. Of course you do have to drop the messed tablespace including contents - which can be quite time-consuming, especially with DMTs and/or tablespace quotas - but if the tablespaces are truly 100% independent of the rest of the database it sounds okay. The only thing I would test (other than a check to see that it seems to work) is whether there is some strange overhead in latching that takes place anywhere because the tablespaces are 'known' to be alien pluggable tablespaces. I believe that the x$bh flag has a special bit set to show that the blocks didn't come from the original database - I don't know if this causes any extra codepath to be used. (It might actually shorten it, of course, as Oracle would know that any block in that tablespace couldn't possibly need any local work done for read consistency). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 December 2002 21:15 Has anyone used transportable tablespaces as a special backup method? Periodically I get a request from our applications people to backup these tables before we run this year-end program so if something goes wrong we can reset everything. And the attention-getter is if we can't recover, you won't get paid again. - Usually nothing goes wrong (thankfully). - We do full backups, obviously, but there are unpleasant consequences for rolling back an enterprise-scale database. The system goes back for everyone. Obviously we can do a TSPITR over on a test system, but I don't like to rely on that alone. - Export works great for small to medium size tables. - Export of large tables is fine, but my experience says that importing a really large table can take a LOOONG time, a frightening prospect during an emergency. - It occurs to me that making the tablespace read-only and performing a transportable export should work great. These large tables are in their own tablespace. The application doesn't any RI in Oracle. - Recovery should be a matter of dropping the existing tablespace, copying the backup datafile off tape, running the import procedure, and making the tablespace read-write. Much faster than the true import. Am I missing something? I plan to try this on a test system to make sure I have the right syntax. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Transportable Tablespaces as backup?
I did that once. And did not run into any problems. HP-UX 11.0 Oracle 8.1.7.4. Worked rather well to my surprise. Never thought that TTS could be so useful! For me, the time consuming part was altering the source TBS to read-only mode as the database was rather busy at the time. We also had two databases on the same server share one datafile! Both using it in read-only mode. TTS is a neat thing :) - Kirti -Original Message- Sent: Wednesday, December 18, 2002 3:26 PM To: Multiple recipients of list ORACLE-L Someone asked the same question at one of my seminars recently, and I couldn't think of a good reason why - for THEIR circumstances - it would be a bad idea. Of course you do have to drop the messed tablespace including contents - which can be quite time-consuming, especially with DMTs and/or tablespace quotas - but if the tablespaces are truly 100% independent of the rest of the database it sounds okay. The only thing I would test (other than a check to see that it seems to work) is whether there is some strange overhead in latching that takes place anywhere because the tablespaces are 'known' to be alien pluggable tablespaces. I believe that the x$bh flag has a special bit set to show that the blocks didn't come from the original database - I don't know if this causes any extra codepath to be used. (It might actually shorten it, of course, as Oracle would know that any block in that tablespace couldn't possibly need any local work done for read consistency). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 18 December 2002 21:15 Has anyone used transportable tablespaces as a special backup method? Periodically I get a request from our applications people to backup these tables before we run this year-end program so if something goes wrong we can reset everything. And the attention-getter is if we can't recover, you won't get paid again. - Usually nothing goes wrong (thankfully). - We do full backups, obviously, but there are unpleasant consequences for rolling back an enterprise-scale database. The system goes back for everyone. Obviously we can do a TSPITR over on a test system, but I don't like to rely on that alone. - Export works great for small to medium size tables. - Export of large tables is fine, but my experience says that importing a really large table can take a LOOONG time, a frightening prospect during an emergency. - It occurs to me that making the tablespace read-only and performing a transportable export should work great. These large tables are in their own tablespace. The application doesn't any RI in Oracle. - Recovery should be a matter of dropping the existing tablespace, copying the backup datafile off tape, running the import procedure, and making the tablespace read-write. Much faster than the true import. Am I missing something? I plan to try this on a test system to make sure I have the right syntax. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Enabling export transportable tablespaces
Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0 I need to move some of my production tablespaces to development system. I was unable to use transprtable tablespace feature. When i executed the EXP transport_tablespaces=y tablespaces= users file=tts.dmp the output will be like this Export done in WE8ISO8859p1 character set and WE8ISO8859p1 NCHAR character set EXP-00017: feature Export transportable tablespaces is needed, but not present in database ORA-00439: feature not enabled:Export transportable tablespaces EXP-0: Export terminated unsuccessfully I found Export transportable tablespaces parameter in V$OPTION and it was set to false. How I can be able to set it to true. Early replies appriciated Banarasi Babu T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Banarasi Babu TIndonet -HYD INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Enabling export transportable tablespaces
Banarasi Are you using the Standard Edition of 8i, if so then tts is not available. You need the Enterprise edition HTH John -Original Message- Sent: 19 November 2002 13:18 To: Multiple recipients of list ORACLE-L Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0 I need to move some of my production tablespaces to development system. I was unable to use transprtable tablespace feature. When i executed the EXP transport_tablespaces=y tablespaces= users file=tts.dmp the output will be like this Export done in WE8ISO8859p1 character set and WE8ISO8859p1 NCHAR character set EXP-00017: feature Export transportable tablespaces is needed, but not present in database ORA-00439: feature not enabled:Export transportable tablespaces EXP-0: Export terminated unsuccessfully I found Export transportable tablespaces parameter in V$OPTION and it was set to false. How I can be able to set it to true. Early replies appriciated Banarasi Babu T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Banarasi Babu TIndonet -HYD INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Enabling export transportable tablespaces
Babu - Two ideas for you. What is your COMPATIBLE parameter set? Enter the command show parameter compatible. Next, look in v$option with select value from v$option where parameter = 'Export transportable tablespaces'; Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 19, 2002 7:18 AM To: Multiple recipients of list ORACLE-L Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0 I need to move some of my production tablespaces to development system. I was unable to use transprtable tablespace feature. When i executed the EXP transport_tablespaces=y tablespaces= users file=tts.dmp the output will be like this Export done in WE8ISO8859p1 character set and WE8ISO8859p1 NCHAR character set EXP-00017: feature Export transportable tablespaces is needed, but not present in database ORA-00439: feature not enabled:Export transportable tablespaces EXP-0: Export terminated unsuccessfully I found Export transportable tablespaces parameter in V$OPTION and it was set to false. How I can be able to set it to true. Early replies appriciated Banarasi Babu T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Banarasi Babu TIndonet -HYD INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Enabling export transportable tablespaces
Are you on Standard Edition or Enterprise Edition? I guess this feature is not available in Standard Edition. You can check it by logging in to SQL*PLUS and it will show the header like this SQL*Plus: Release 8.0.4.0.0 - Production on Tue Nov 19 20:2:16 2002 (c) Copyright 1997 Oracle Corporation. All rights reserved. Connected to: Oracle8 Enterprise Edition Release 8.0.6.1.0 - Production PL/SQL Release 8.0.6.1.0 - Production SQL Regards Naveen -Original Message- Sent: Tuesday, November 19, 2002 6:48 PM To: Multiple recipients of list ORACLE-L Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0 I need to move some of my production tablespaces to development system. I was unable to use transprtable tablespace feature. When i executed the EXP transport_tablespaces=y tablespaces= users file=tts.dmp the output will be like this Export done in WE8ISO8859p1 character set and WE8ISO8859p1 NCHAR character set EXP-00017: feature Export transportable tablespaces is needed, but not present in database ORA-00439: feature not enabled:Export transportable tablespaces EXP-0: Export terminated unsuccessfully I found Export transportable tablespaces parameter in V$OPTION and it was set to false. How I can be able to set it to true. Early replies appriciated Banarasi Babu T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Banarasi Babu TIndonet -HYD INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Enabling export transportable tablespaces
you need to buy this feature - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 5:18 AM Hi gurus please help me!! I was using ORACLE 8.1.7 on window NT 4.0 I need to move some of my production tablespaces to development system. I was unable to use transprtable tablespace feature. When i executed the EXP transport_tablespaces=y tablespaces= users file=tts.dmp the output will be like this Export done in WE8ISO8859p1 character set and WE8ISO8859p1 NCHAR character set EXP-00017: feature Export transportable tablespaces is needed, but not present in database ORA-00439: feature not enabled:Export transportable tablespaces EXP-0: Export terminated unsuccessfully I found Export transportable tablespaces parameter in V$OPTION and it was set to false. How I can be able to set it to true. Early replies appriciated Banarasi Babu T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Banarasi Babu TIndonet -HYD INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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.com -- Author: Krishna Rao Kakatur INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: transportable tablespaces
Matt, 8i admin guide, search for transport, in that chapter is limitations, they are all listed there. joe [EMAIL PROTECTED] 08/02/01 09:21AM Rachel, Which doc did you find that in? Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 5:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: transportable tablespaces According to the docs you must be on the same OS, down to patches, and the same version of Oracle, again down to patches. Rachel From: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: transportable tablespaces Date: Wed, 01 Aug 2001 12:41:38 -0800do transportable tablespaces work between different OSes? I wouldn't think so, but I thought I'd ask. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: transportable tablespaces
Title: RE: transportable tablespaces Rachel, Which doc did you find that in? Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 5:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: transportable tablespaces According to the docs you must be on the same OS, down to patches, and the same version of Oracle, again down to patches. Rachel From: Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: transportable tablespaces Date: Wed, 01 Aug 2001 12:41:38 -0800 do transportable tablespaces work between different OSes? I wouldn't think so, but I thought I'd ask. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
transportable tablespaces
Title: transportable tablespaces do transportable tablespaces work between different OSes? I wouldn't think so, but I thought I'd ask. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
Re: transportable tablespaces
According to the docs you must be on the same OS, down to patches, and the same version of Oracle, again down to patches. Rachel From: Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: transportable tablespaces Date: Wed, 01 Aug 2001 12:41:38 -0800 do transportable tablespaces work between different OSes? I wouldn't think so, but I thought I'd ask. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: transportable tablespaces
Title: transportable tablespaces Only if the datafiles are the same between the two systems. As far as I have been able to test, this only works with Sun and HP.The datafiles in both cases are thesame, and Oracle will not complain about them.There are probably some caveats.. suchas 32 vs. 64 bit, and different versions of oracle not available on different platforms,little endian vs. big endian... and soon. I don't think it will work with any other unix systems. You can always give it a try -- let us know. Nick -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 01, 2001 1:42 PMTo: Multiple recipients of list ORACLE-LSubject: transportable tablespaces do transportable tablespaces work between different OSes? I wouldn't think so, but I thought I'd ask. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
RE: How to use Export Transportable Tablespaces
Thanks a whole bunch Tim, but one final question.
Why did you drop the tablespaces
drop tablespace stage_haines_data including contents;
drop tablespace stage_haines_index including contents;
-Original Message-
Sent: Wednesday, February 07, 2001 4:36 AM
To: Multiple recipients of list ORACLE-L
Filtering attachments is a reasonable precaution, I guess. Here is the
pasted script:
#!/bin/ksh
# This script is used to transport tablespaces from STAGE database to CARS.
# It needs two parameters as "From DB" and "To DB".
#
# Created : 2/16/2000 by Pawan Sanwal (Whittman-Hart)
#
# This script need to run from the same machine where both databases exist.
#
# Exit if not all the arguments supplied.
if [ "$1x" = "x" ] || [ "$2x" = "x" ]; then
echo ;
echo "Usage : transport.sh From Stage Oracle SID To Cars Oracle SID";
echo ;
exit 1;
fi
#
# The tablespaces should always be transported from Stage to Cars databases.
#
if [ `echo $1|grep stage /tmp/log 2/tmp/err; echo $?` -eq 1 ] ||
[ `echo $2|grep cars /tmp/log 2/tmp/err; echo $?` -eq 1 ]; then
echo ;
echo "Usage : transport.sh From Stage Oracle SID To Cars Oracle SID";
echo ;
exit 1;
fi
export ORACLE_SID=$2
#
# Ask for system user passwords on both databases.
#
echo
echo "Enter system user password for "$2" :\c"
echo [8m"\c"
read secondpwd
echo [0m
echo "Enter system user password for "$1" :\c"
echo [8m"\c"
read firstpwd
echo [0m
#
# Gather datafiles information for the transportable tablespaces, viz.
# tablespaces stage_haines_data and stage_haines_index.
#
ls -1 /u0??/oradata/$1/stage_haines*data*dbf /tmp/temp1 2/tmp/err
ls -1 /u0??/oradata/$1/stage_haines*index*dbf /tmp/temp1 2/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*data*dbf /tmp/temp2 2/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*index*dbf /tmp/temp2 2/tmp/err
#
# Exit if this script is being run from different machine than where
databases
# exist.
#
if [ `cat /tmp/temp1|grep "stage_haines" /tmp/log 2/tmp/err; echo $?` -eq
1 ] ||
[ `cat /tmp/temp2|grep "stage_haines" /tmp/log 2/tmp/err; echo $?` -eq
1 ]; then
echo "The databases do not exist on this machine. Please run the script";
echo "from the machine where databases exist.";
echo ;
exit 1;
fi
paste /tmp/temp1 /tmp/temp2 /tmp/copy_temp.sh
sed 's/^/cp /' /tmp/copy_temp.sh /tmp/copy_files.sh
sqlplus -s system/$secondpwd@$2 !
set pages 500
set lines 200
set head off
set feedback off
set verify off
set term off
drop tablespace stage_haines_data including contents;
drop tablespace stage_haines_index including contents;
!
export ORACLE_SID=$1
sqlplus -s system/$firstpwd@$1 !
set pages 500
set head off
set term off
execute
sys.dbms_tts.transport_set_check('STAGE_HAINES_DATA,STAGE_HAINES_INDEX',TRUE
);
spool /tmp/violations
select * from sys.transport_set_violations;
spool off
!
nohup grep "no rows selected" /tmp/violations.lst /dev/null
if [ $? = 1 ]; then
echo "Tablespaces are not self-contained... exiting...";
exit 1;
fi
#
# Alter the tablespaces in STAGE database to read only mode.
#
export ORACLE_SID=$1
sqlplus -s system/$firstpwd@$1 !
set pages 500
set head off
set term off
set verify off
set feedback off
alter tablespace stage_haines_data read only;
alter tablespace stage_haines_index read only;
!
#
# Export the tablespaces metadata from the Stage database.
#
exp userid=stage_user/stage_user@$1 file=/tmp/stage.dmp
transport_tablespace=y tablespaces=stage_haines_data, stage_haines_index
triggers=n constraints=n
#
# Copy the datafiles for the transportable tablespaces to the CARS
directoies.
#
chmod 777 /tmp/copy_files.sh
/tmp/copy_files.sh
#
# Alter the tablespaces in STAGE database read write.
#
sqlplus -s system/$firstpwd@$1 !
set pages 500
set head off
set term off
set verify off
set feedback off
alter tablespace stage_haines_data read write;
alter tablespace stage_haines_index read write;
!
#
# Import the tablespaces metadata into the CARS database.
#
export ORACLE_SID=$2
imp userid=system/$secondpwd@$2 file=/tmp/stage.dmp transport_tablespace=y
datafiles=`cat /tmp/temp2`
#
# As stage user grant SELECT privilege to stage_user_role on the transported
# objects in the cars database.
#
sqlplus -s system/$secondpwd@$2 !
set pages 500
set head off
set term off
set verify off
set feedback off
col password new_value oldpswd noprint
col tmppassword new_value tmppswd noprint
col loweruser new_value lower_user noprint
select lower(username) loweruser, password
from dba_users
where username = UPPER('stage');
create user "lower_user" identified by temp123;
select password tmppassword from dba_users
where username = 'lower_user';
drop user "lower_user";
alter user stage identified by values 'tmppswd';
connect stage/temp123@$2
grant select on stage.haines_bu
RE: How to use Export Transportable Tablespaces
This process was repeated monthly. So, all references in the target database were
dropped each time the process was performed.
[EMAIL PROTECTED] 02/07/01 11:56AM
Thanks a whole bunch Tim, but one final question.
Why did you drop the tablespaces
drop tablespace stage_haines_data including contents;
drop tablespace stage_haines_index including contents;
-Original Message-
Sent: Wednesday, February 07, 2001 4:36 AM
To: Multiple recipients of list ORACLE-L
Filtering attachments is a reasonable precaution, I guess. Here is the
pasted script:
#!/bin/ksh
# This script is used to transport tablespaces from STAGE database to CARS.
# It needs two parameters as "From DB" and "To DB".
#
# Created : 2/16/2000 by Pawan Sanwal (Whittman-Hart)
#
# This script need to run from the same machine where both databases exist.
#
# Exit if not all the arguments supplied.
if [ "$1x" = "x" ] || [ "$2x" = "x" ]; then
echo ;
echo "Usage : transport.sh From Stage Oracle SID To Cars Oracle SID";
echo ;
exit 1;
fi
#
# The tablespaces should always be transported from Stage to Cars databases.
#
if [ `echo $1|grep stage /tmp/log 2/tmp/err; echo $?` -eq 1 ] ||
[ `echo $2|grep cars /tmp/log 2/tmp/err; echo $?` -eq 1 ]; then
echo ;
echo "Usage : transport.sh From Stage Oracle SID To Cars Oracle SID";
echo ;
exit 1;
fi
export ORACLE_SID=$2
#
# Ask for system user passwords on both databases.
#
echo
echo "Enter system user password for "$2" :\c"
echo [8m"\c"
read secondpwd
echo [0m
echo "Enter system user password for "$1" :\c"
echo [8m"\c"
read firstpwd
echo [0m
#
# Gather datafiles information for the transportable tablespaces, viz.
# tablespaces stage_haines_data and stage_haines_index.
#
ls -1 /u0??/oradata/$1/stage_haines*data*dbf /tmp/temp1 2/tmp/err
ls -1 /u0??/oradata/$1/stage_haines*index*dbf /tmp/temp1 2/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*data*dbf /tmp/temp2 2/tmp/err
ls -1 /u0??/oradata/$2/stage_haines*index*dbf /tmp/temp2 2/tmp/err
#
# Exit if this script is being run from different machine than where
databases
# exist.
#
if [ `cat /tmp/temp1|grep "stage_haines" /tmp/log 2/tmp/err; echo $?` -eq
1 ] ||
[ `cat /tmp/temp2|grep "stage_haines" /tmp/log 2/tmp/err; echo $?` -eq
1 ]; then
echo "The databases do not exist on this machine. Please run the script";
echo "from the machine where databases exist.";
echo ;
exit 1;
fi
paste /tmp/temp1 /tmp/temp2 /tmp/copy_temp.sh
sed 's/^/cp /' /tmp/copy_temp.sh /tmp/copy_files.sh
sqlplus -s system/$secondpwd@$2 !
set pages 500
set lines 200
set head off
set feedback off
set verify off
set term off
drop tablespace stage_haines_data including contents;
drop tablespace stage_haines_index including contents;
!
export ORACLE_SID=$1
sqlplus -s system/$firstpwd@$1 !
set pages 500
set head off
set term off
execute
sys.dbms_tts.transport_set_check('STAGE_HAINES_DATA,STAGE_HAINES_INDEX',TRUE
);
spool /tmp/violations
select * from sys.transport_set_violations;
spool off
!
nohup grep "no rows selected" /tmp/violations.lst /dev/null
if [ $? = 1 ]; then
echo "Tablespaces are not self-contained... exiting...";
exit 1;
fi
#
# Alter the tablespaces in STAGE database to read only mode.
#
export ORACLE_SID=$1
sqlplus -s system/$firstpwd@$1 !
set pages 500
set head off
set term off
set verify off
set feedback off
alter tablespace stage_haines_data read only;
alter tablespace stage_haines_index read only;
!
#
# Export the tablespaces metadata from the Stage database.
#
exp userid=stage_user/stage_user@$1 file=/tmp/stage.dmp
transport_tablespace=y tablespaces=stage_haines_data, stage_haines_index
triggers=n constraints=n
#
# Copy the datafiles for the transportable tablespaces to the CARS
directoies.
#
chmod 777 /tmp/copy_files.sh
/tmp/copy_files.sh
#
# Alter the tablespaces in STAGE database read write.
#
sqlplus -s system/$firstpwd@$1 !
set pages 500
set head off
set term off
set verify off
set feedback off
alter tablespace stage_haines_data read write;
alter tablespace stage_haines_index read write;
!
#
# Import the tablespaces metadata into the CARS database.
#
export ORACLE_SID=$2
imp userid=system/$secondpwd@$2 file=/tmp/stage.dmp transport_tablespace=y
datafiles=`cat /tmp/temp2`
#
# As stage user grant SELECT privilege to stage_user_role on the transported
# objects in the cars database.
#
sqlplus -s system/$secondpwd@$2 !
set pages 500
set head off
set term off
set verify off
set feedback off
col password new_value oldpswd noprint
col tmppassword new_value tmppswd noprint
col loweruser new_value lower_user noprint
select lower(username) loweruser, password
from dba_users
where username = UPPER('stage');
create user "lower_user" identified by temp123;
select password tmppassword from dba_
How to use Export Transportable Tablespaces
Does anyone have an example of how to use transportable tablespaces with export/import. I want export a user (8.1.6 database) source and import fromuser touser(8.1.6 database) target. I tried to import fromuser/ touser, but many contraints were not created and lost some data so I was told to try transportable tables. Can't find any good examples on how to use this new feature. Can someone please help me. Thanks Larry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: How to use Export Transportable Tablespaces
There are straightforward examples in the 8.1.7 documentation. I don't know if that feature is available in 8.1.6. But regardless, you should investigate WHY the fromuser/touser didn't achieve the desired results or I fear you'll be disappointed again. Jim [EMAIL PROTECTED] 02/06/01 12:22PM Does anyone have an example of how to use transportable tablespaces with export/import. I want export a user (8.1.6 database) source and import fromuser touser(8.1.6 database) target. I tried to import fromuser/ touser, but many contraints were not created and lost some data so I was told to try transportable tables. Can't find any good examples on how to use this new feature. Can someone please help me. Thanks Larry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Jim Conboy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How to use Export Transportable Tablespaces
Tim Can you cut and paste the script into your reply, because your attachment is not working. tia -Original Message- Sent: Tuesday, February 06, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Exporting Tablespaces is not achieved using fromuser/touser. The entire tablespace is transported, no matter whose objects are in it. Actually, just the meta data is exported and imported. The other step is to physically copy the files supporting the tablespace to a new location and attaching them to the the target database. See attached file for an example. [EMAIL PROTECTED] 02/06/01 02:10PM There are straightforward examples in the 8.1.7 documentation. I don't know if that feature is available in 8.1.6. But regardless, you should investigate WHY the fromuser/touser didn't achieve the desired results or I fear you'll be disappointed again. Jim [EMAIL PROTECTED] 02/06/01 12:22PM Does anyone have an example of how to use transportable tablespaces with export/import. I want export a user (8.1.6 database) source and import fromuser touser(8.1.6 database) target. I tried to import fromuser/ touser, but many contraints were not created and lost some data so I was told to try transportable tables. Can't find any good examples on how to use this new feature. Can someone please help me. Thanks Larry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Jim Conboy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Larry Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
