Home » RDBMS Server » Server Utilities » SQL Loader not picking all rows from .csv file
SQL Loader not picking all rows from .csv file [message #72963] Tue, 23 December 2003 19:03 Go to next message
Chander
Messages: 4
Registered: November 2001
Junior Member
Hi,

I am using SQL Loader to fetch data from a .csv file into our database (oracle). the things work fine when the number of rows is less. When the number of rows of data increases to somewhere around 150-200 it does not loads the rows after loading the data of around 95 rows because of which we are not getting the whole data exported into our database. Can anyone please help me out as this is beginning to become critical for us.

Regards,
Chander

Report message to a moderator

Re: SQL Loader not picking all rows from .csv file [message #72964 is a reply to message #72963] Wed, 24 December 2003 01:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
could you post the logfile for the sqlldr session?

Report message to a moderator

Re: SQL Loader not picking all rows from .csv file [message #72965 is a reply to message #72964] Wed, 24 December 2003 02:52 Go to previous message
Chander
Messages: 4
Registered: November 2001
Junior Member
Thanks Mahesh... SQL Loader was performing properly. I misread the situation completely. Thanks for the prompt response. Appreciate it :-)

Report message to a moderator

Previous Topic: Migrate Db from UNIX to Windows.
Next Topic: will hourly export affect the system performance?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 12 13:52:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.