Re: Copy Database from NT to W2K

giuseppe.didodo_at_bluewin.ch (Giuseppe) wrote in message news:<df5fda08.0212260316.2c6a8176_at_posting.google.com>...
> Hi guys
>
> sorry for my delay to answer.
>
> We got it up, it finally works now ! We left the DB on the machine
> with NT4 and tried to upgrade the machine to W2K. We had some troubles
> with drivers for the RAID controller, but when we solved that, we
> could upgrade the machine. Because the DB was already on 8.1.7.4,
> everything was fine.
>
> I still don`t understand why it didn`t work, I did that a couple of
> times and it always worked. Ok, 90% I did it running under UNIX, NT
> just two or three times.
>
> Thanks again for your help!
> merry christmas and happy new year and lot less DB problems...

Hi, Giuseppe,

There shouldn't be any problem directly moving datafiles between Windows NT and 2000. But I have yet to find official endorsement from either Oracle or Microsoft saying this is allowed. (See the last paragraph at http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=b3cb12d6.0206091644.76926b5f%40posting.google.com and the entire thread, which is mainly about the potential use of datafiles across OSes)

Ever since my test on my NT and W2K dual boot computer using the same datafiles, I always pay close attention to technical papers and books on NTFS difference between NT and W2k. I still haven't found a definitive answer from an expert saying Oracle datafiles are safe to be directly moved from one to the other. So please post back here if you find any problem later on. The ultimate question is, should NT and W2K be considered as two OSes or just one but two versions? And generally, how different should two versions of one OS be to require exp/imp instead of directly copying Oracle datafiles? Or it's the filesystem, not OS, that matters?

Yong Huang Received on Thu Dec 26 2002 - 17:39:45 CST