Re: Transfer Data from SQL Server to Oracle 9i via DTS, very slowww

xtanto_at_hotmail.com (Krist) wrote in message news:<cb48a3b.0406290237.6d9a2b87_at_posting.google.com>...
> Hi All,
>
> I need to transfer data from SqlServer2000 to Oracle 9i via Export
> Wizard in SQL Server 2000 (which in turn create DTS package on this),
> SQLServer is accessing Oracle 9i via ODBC.
>
> To transfer 20000 rows takes 3 minutes so, if it is 1 Million rows, it
> will become three hours, is there any way to make it faster ?
> May be using other method ?
>
> Thank you for any help,
> Krist

Maybe write it to a file with fixed width columns, ftp it to the server and use sqlldr?

jg

--
@home.com is bogus.
http://hosted.ap.org/dynamic/stories/P/PODIATRIST_FRAUD?SITE=CADIU&SECTION=HOME&TEMPLATE=DEFAULT