RE: (NEW) very interesting thing about migrate db from different OS(oracle 9.2.0.4,not 10G)
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: <biti_rainy@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Jan 2005 10:06:55 -0500
I personal don't have first hand experience wih this but...
a while back on another list there was a long thread on the very
subject.
Seems it all has mostly to do with "Little Endian" vs. "Big Endian".
http://www.webopedia.com/TERM/b/big_endian.html
Once of the dba's on the list promised that he regularly moved (copied)=20
his Oracle database on windows x86 (NTFS?) to Red Hat Linux x86 (EXT3?).
I never got the time to try it.
I do remember that several people on the list (smarter than I) explained
clearly that=20
it was NOT the file system type that makes the difference but "Little
Endian" vs. "Big Endian" issue.
hth
Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of biti_rainy
Sent: Thursday, January 20, 2005 1:24 AM
To: oracle-l
Subject: (NEW) very interesting thing about migrate db from different
OS(oracle 9.2.0.4,not 10G)
hi,all
we find a very interesting thing:
we copy the WINDOWS2000 datafile to linux (they have the same
byte order)
and , dd a linux datafile header to cover the windows datafile
header(the header block is not include in dba_data_files),the
block is not seem in database ,it is for OS. ls -l can see
,the datafile size is bigger than dba_data_files for one oracle
block.
when we change the OS file header,we can create controlfile and
open the database ,and we can query /create table ... etc.
the db version is oracle9204,not 10g. and someone told me that
he can copy the datafile from windows and solaris for x86 pc to
linux , and not change the header with oracle8i.
is there someone can discuss it?
=20
Best regards
msn: biti_rainy@xxxxxxxxxxx
a dba from alibaba(china)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
