RE: (NEW) very interesting thing about migrate db from different OS(oracle 9.2.0.4,not 10G)

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_hotmail.com
a dba from alibaba(china)

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 21 2005 - 10:21:23 CST