Oracle-L: RE: Transportable tablespaces

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Wed, 22 Oct 2003 15:44:25 -0800
Message-ID: <F001.005D4001.20031022154425@fatcity.com>

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" <DGoulet_at_vicr.com> wrote:
> Humm, That's interesting. Transportable tablespaces were introduced
> in 8i, 9i allowed us to have multiple block sizes at the tablespace
> level for flexibility. But I've not heard that one can transport a
> tablespace/datafile across platforms. What a wonderful way to trash
> all of those Windoze servers out there for Linux!!
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -----Original Message-----
> Sent: Tuesday, October 21, 2003 9:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Listers
>
> Saw this on SearchOracle
> What new features are customers excited about in 10G?
> Abramson: What they've done is given you complete flexibility. They
> have introduced transportable table spaces, so all you have to do is
> export metadata and just copy files across during an upgrade. You
> don't have to
> do a full extraction. I've been in a situation were a company was on
> Sun
> and moving to HP, and they wanted to know how to do it. I told them
> that
> you just unload the database and reload the database. It sounds easy,
> but
> with two terabytes of data it's not unless you have transportable
> table
> spaces.
>
> Can anyone confirm that this is true, that is, the implication that I
> can copy a transportable tablespace from Sun to HP or vice versa
> without issue. I suppose then is it big endian - little endian
> constrained or not
>
> Cheers
>
>
> --
> =================================================
> Peter McLarty E-mail: Peter.Mclarty_at_mincom.com
> Technical Consultant WWW: http://www.mincom.com
> APAC Technical Services Phone: +61 (0)7 3303 3461
> Brisbane, Australia Mobile: +61 (0)402 094 238
> Facsimile: +61 (0)7 3303 3048
> =================================================
> "If people did not sometimes do silly things, nothing intelligent
> would ever get done."
> - Ludwig Wittgenstein
> =================================================
> Mincom "The People, The Experience, The Vision"
>
> =================================================
>
> This transmission is for the intended addressee only and is
> confidential information. If you have received this transmission in
> error, please delete it and notify the sender. The contents of this
> e-mail are the opinion of the writer only and are not endorsed by the
> Mincom Group of companies unless expressly stated otherwise.
>
>
>
>
> --
> This transmission is for the intended addressee only and is
> confidential information. If you have received this transmission in
> error, please notify the sender and delete the transmission. The
> contents of this e-mail are the opinion of the writer only and are not
> endorsed by the Mincom Group of companies unless expressly stated
> otherwise.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Peter.McLarty_at_mincom.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Goulet, Dick
> INET: DGoulet_at_vicr.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing).

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henry Poras
  INET: hporas_at_etal.uri.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete Sharman
  INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: hporas_at_etal.uri.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Oct 22 2003 - 18:44:25 CDT