ETL and Data Integration tools - Modern ETL software for everyone

Hi

Im trying to load these files into Oracle from csv files and when it reaches 650K the tool fails with an error message of 'Out of memory'

I have increased the Virtual memory, the machine itself has 2G, and deleted all temp files etc.

Any ideas on how else I can get this to run?

thanks

Hello

There are several ways of loading data into oracle

OleDB
ODBC
Direct path
Conventional path

You did not say which one are you using

Also is there any additional transformations?
Sorting groupping etc

Peter

Hi Sorry its an ODBC link

Im not doing any additional transformations, just a direct load

Have you tried conventional path?

ODBC is not the fastest way of loading the data

Version of oracle and version of odbc driver?

Peter

Hi

Sorr I think Im getting a bit confused, the connection I am using in the ETL tool is an Oracle connection not ODBC. But that uses an ODBC connection at the back end, I think

sorry Im not being much help

In this case can you post here a screen shot of the data writer connection so we can see all the options.

Also what is your version of Oracle?

Mike