Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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=DEFAULTReceived on Thu Jul 01 2004 - 18:19:11 CDT
![]() |
![]() |