Home » RDBMS Server » Server Utilities » SQLLDR80 Insertion problem
SQLLDR80 Insertion problem [message #613342] Mon, 05 May 2014 04:33 Go to next message
lovingipsita
Messages: 1
Registered: May 2014
Junior Member
When I am trying to insert 240000 records. But after 1500 records commit point reached data is not uploading. Is it because rollback segments are full. please help. this is the control file

load data
infile 'D:\Sale_Dist_With_Total1mod.csv'
infile 'D:\Sale_Dist_With_Total2mod.csv'
infile 'D:\Sale_Dist_With_Total3mod.csv'
infile 'D:\Sale_Dist_With_Total4mod.csv'
infile 'D:\Sale_Dist_With_Total5mod.csv'
infile 'D:\Sale_Dist_With_Total6mod.csv'
into table FINEINDIA
fields terminated by ',' optionally enclosed by '"'
(FINEID, NAME,ADDRESS,STATE,CITY,PHONE1,PHONE2,AMOUNT)
Re: SQLLDR80 Insertion problem [message #613345 is a reply to message #613342] Mon, 05 May 2014 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 60004
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Copy and paste the loader log file.

Re: SQLLDR80 Insertion problem [message #613359 is a reply to message #613345] Mon, 05 May 2014 09:07 Go to previous message
BlackSwan
Messages: 23154
Registered: January 2009
Senior Member
You claim a problem but provide us no details so we can not guess what is wrong.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Previous Topic: how to handle nulls for date field in control file
Next Topic: schema import using impdp
Goto Forum:
  


Current Time: Sat Dec 20 11:37:24 CST 2014

Total time taken to generate the page: 0.07722 seconds