Fastest Way to Transfer Data to Oracle 8 Database

[Barabas]

Trying to Do..


Transfer Data from a SQL 7 Database on NT Server via DTS job to Oracle 8iDatabase Table on another NT Server.

This Oracle 8i DB Table has no indexes.


Currently i can transfer about 8000 rows in 1 minute, i am seeking to lower this time by as much as possible


I know this is kind of a SQL Server Question but perhaps some1 would have encountered this before.

Again any advice/pointers are most welcome.

[gbrabham]

SQLServer can only pump data so fast (as well as the connection
between the servers). On the Oracle side, I would have a large
rollback segment and if the table is being logged, you might consider
not logging for the loading of the table.

Gregg

[TomazZ]

Try connecting to Oracle from MS DTS with Oracle OLE DB provider. It seems faster than MS.

If this should be regular data transfer, try to find other means of transport than MS DTS.

The good old sql*loader and some scripting?

[Barabas]

thanks guys, i tried ole before it speeded things up slightly.


Thanks again

[abhaysk]

Note : The N/W speed ( Data transfer ) also matters. Which will limit the Tools that extract data and send across n/w.