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

Hi,

The number of the tables to be transferref is about 130 tables. Some tables has more than 150 columns.

Using DTS, I have to define the data transfer task one by one. (or is therre any automated way for this ?)

Given this condition, is using tools like Oracle Migration Work bench will make it easier ?

Thank you,
Krist

"Paul Brewer" <nothing_at_nowhere.com> wrote in message news:<40df1fc3_2_at_mk-nntp-1.news.uk.worldonline.com>...
> "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 Mon Jun 28 2004 - 06:39:55 CDT