Re: Copying a DB from NT to Linux occurs a ORA-01516

I may not be 100% correct about this, but as far as I can think Oracle does NOT use a 'native' internal representation for data.

Instead, it uses its own 'proprietary' internal representation. E.g. take a look at Oracle's way of storing numbers - it's like nothing else on this planet! It's certainly QUITE different from any native hardware scheme for numbers that I have ever seen.

Conclusion: Oracle converts from its own storage scheme to the 'native' hardware/operating system scheme at some point. This makes me think that there's at least a possibility that the Linux and NT databases are cross-compatible. But it may be wishful thinking!

Steve Parfitt

Liz Reen wrote:
>
> In article <9ltmnb$eav$1_at_newsread2.nexgo.de>, k.kalweit_at_gmx.de says...
> > But I can mount the database so, the control files doesn't seem to be
> > corrupt. Are the binary data between Linux and NT Oracle Version different?
> > Both are intel systems so I think there are no problems how the data are
> > stored.
> >
> > Regards,
> >
> > Kristian.
> >
> >
> >
> >
> Hardware has nothing to do with it. These are two totally different
> operating systems. The problems is not the file system type. That
> hurdle was crossed when you copied the files. It is the internal
> representation of the data which is different (think long, floating
> point etc.) Linux may be a "recent" o/s, which is based on Unix which
> is anything, but recent. Export/Import is the only answer.
>
> Liz
Received on Wed Aug 22 2001 - 20:24:03 CDT