Re: Moving Database from NT -> AIX

Hi
You need to create tablespaces (make sure the names are same in both environment)
because data files need the specific paths. And are different in NT and Unix (AIX) . Like in NT you specify as c:\mydir\oracle\sid\mydatafile.dbf
where as in Unix or AIX you specify the path as /mydir/oracle/sid/mydatafile.dbf.

Once you create the tablespaces then you can import (from the full export) the data from NT to AIX , Also use the ignore=y option.
HTH
Pradhan

sherwin_at_my-deja.com wrote:

> Hi,
>
> Is it possible to move all the relevant files for an Oracle 7.3.4.4
> instance from NT4 to AIX4 and, with a bit of path tweaking, get it to
> run? The reason i ask is that i have tried the above, but get the
> following errors when I try and do anything that involves accessing
> control files or data files:
>
> ORA-01565: error in identifying file '/a02/oradata/resd/*******' -
> (always sees the correct file)
>
> ORA-07366: sfifi: invalid file, file does not have valid header block.
>
> This would seem to imply that my NT files are the wrong format for AIX.
> Can anyone confirm/deny this?
>
> Ta
>
> Sherwin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 30 1999 - 22:30:02 CST