Hi All

I am DTS Data from SQL Server 2000 to Oracle 9i.

I am testing it before creating a full fledged system.

I DTS'ed 1 SQL Server Table to Oracle, the table structure on both the
databases are same and there are no BLOB Columns.

To Transfer 1464 rows from SQL Server to Oracle it took
6 mins and 19 secs. But to transfer it the other way from Oracle to SQL
Server it took just 2 secs for the same number of rows. I have checked
the network connections etc and it is fine.

Does anyone know about any settings to be checked on the Oracle side?
And why it takes soo long to transfer from SQL Server to Oracle i.e.
writing of records in Oracle takes this time I reckon.

Exporting to Flat Files/FTP and using sqlldr is a no go as this needs to
happen frequently and to be done on around 50 tables. The number of rows
will not exceed 25000 for each table.

Any help will be highly appreciated.

Thanks
Regards
Laks



*** Sent via Developersdex http://www.developersdex.com ***