|
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 -----
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
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
> --
>
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pete
Sharman
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).
Hemant K Chitale
Oracle 9i Database Administrator Certified
Professional
My personal web site is : http://hkchital.tripod.com
-- Please see the
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
|
