Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Transfer Data from SQL Server to Oracle 9i via DTS, very slowww

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

From: Krist <xtanto_at_hotmail.com>
Date: 29 Jun 2004 03:37:07 -0700
Message-ID: <cb48a3b.0406290237.6d9a2b87@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
Received on Tue Jun 29 2004 - 05:37:07 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US