Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle data file format

Re: Oracle data file format

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 8 Jun 2002 08:42:09 -0700
Message-ID: <adt8kh017co@drn.newsguy.com>


In article <gwhM8.216131$Po6.364306_at_rwcrnsc52.ops.asp.att.net>, "Jim says...
>
>Bad idea. Just use export and import.

Not just a bad idea. It simply won't work.

>Jim
>"Yong Huang" <yong321_at_yahoo.com> wrote in message
>news:b3cb12d6.0206070941.72956f15_at_posting.google.com...
>> Mark Malakanov <markmal_no_spam_at_rogers.com> wrote in message
>news:<3D007251.9050005_at_rogers.com>...
>> > There is so many unixes. Probably it is possible to put window's
>> > datafiles files into INTEL Linux, and may be it will even work,
>> > but nobody can guarantee that, and Oracle Corp will not support.
>>
>> I documented the success of reusing datafiles in WindowsNT and
>> Windows2000 at
>http://www.stormloader.com/yonghuang/computer/OracleIdiosyncrasies.html,
>> Item#9. You may say they're not really different OSes. Well, Microsoft
>> think they are. I have a feeling that the file system and platform
>> byte ordering matter more than the OS label.
>>
>> But more interesting is the test of reusing the same datafile between
>> WindowsWhatever and Intel Linux (has to be Intel Linux, not Sparc e.g.
>> due to byte ordering). Can anyone do this test? If that succeeds which
>> I doubt, then we can try Windows and True64.
>>
>> In any case, all these are unsupported. Somebody I know had a plan to
>> write a program to directly modify datafiles to support cross-platform
>> datafile move. Not sure about his progress. That's even more
>> un-supported!
>>
>> Yong Huang
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Sat Jun 08 2002 - 10:42:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US