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 <hporas_at_etal.uri.edu> 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" <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).
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 - 19:54:25 CDT
