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 Consultant WWW: http://www.mincom.com > > APAC Technical Services Phone: +61 (0)7 3303 3461 > > Brisbane, Australia Mobile: +61 (0)402 094 238 > > Facsimile: +61 (0)7 3303 3048 > > ================================================= > > "If people did not sometimes do silly things, nothing intelligent > > would > > ever > > get done." > > - Ludwig Wittgenstein > > ================================================= > > Mincom "The People, The Experience, The Vision" > > > > ================================================= > > > > This transmission is for the intended addressee only and is > > confidential > > information. If you have received this transmission in error, > please > > delete it and notify the sender. The contents of this e-mail are > the > > opinion of the writer only and are not endorsed by the Mincom Group > > of > > companies unless expressly stated otherwise. > > > > > > > > > > -- > > This transmission is for the intended addressee only and is > > confidential information. If you have received this transmission in > > error, please notify the sender and delete the transmission. The > > contents of this e-mail are the opinion of the writer only and are > > not endorsed by the Mincom Group of companies unless expressly > stated > > otherwise. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [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 for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Henry Poras > 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 for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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).
