Re: Can you copy datafiles from one OS to another?

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Thu, 23 Sep 1999 09:15:37 +0100
Message-ID: <37E9E1A9.E917AAEB@totalise.co.uk>

A Hairy Old Man wrote:
>
> Hello all,
>
> This came out of a discussion I had with another Oracle techie over a
> beer (uhmm.... Ok, over several beers) so I don't even know if it
> makes sense.
>
> Anyway, is it possible to copy datafiles from one OS say Unix to NT or
> VMS and rebuild an instance? If so, what are the constraints?
>
> We were guessing that it could only be tables and indexes as opposed
> to system, rollbacks, redologs, etc. and maybe only among same cpu
> systems with same file block factor. But again, we were pretty much
> blasted.
>
> Any comments are very welcomed, as well as some pain killers : )

Hi
If you want to do this then 'replicate' your DB rather than copying files around, which could lead to internal datatype problems ie do both CPUS have the same endianess/word size....

Martin Received on Thu Sep 23 1999 - 03:15:37 CDT