Re: Exporting Data from Oracle 9i /Win into Oracle 9i/AIX

"Krist" <xtanto_at_hotmail.com> wrote in message news:cb48a3b.0406240653.87ffd14_at_posting.google.com...
> Hi All,
>
> I have data on SQL server 2000 that should be transferred into Oracle
> 9i on AIX.
>
> I plan to transferred it into Oracle 9i/Win2k first, that Exporting it
> into .DMP then Import the .DMP into Oracle 9i/AIX.
>
> Is it possible ?
> Or is it not a good approach for this ?
>
> Thanks for any comments,
> xtanto

Krist,

Yes this should work OK, as long as the AIX Oracle version isn't lower than the Windows one. If you are ftp'ing the export dump dump make sure the mode is binary.
But if you are using something like a DTS job to get it from SQL Server to Oracle, why not just do it directly from A to C and miss out B? Just set up an Oracle client ODBC connection from your Windows box to the AIX box, and it should go in one pass using SQL*Net (wash my mouth out, Net8, wash my mouth out, OracleNet...;-)

Regards,
Paul Received on Sun Jun 27 2004 - 14:27:14 CDT