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).
Received on Wed Oct 22 2003 - 11:09:33 CDT
