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: 68624
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: 26766
Registered: January 2009
Location: SoCal
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: Thu Mar 28 03:33:23 CDT 2024