Home » RDBMS Server » Server Utilities » SQLLDR80 Insertion problem
SQLLDR80 Insertion problem [message #613342] Mon, 05 May 2014 04:33 Go to next message
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 '"'
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: 65144
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
Messages: 25571
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: schema import using impdp
Next Topic: problem Import
Goto Forum:

Current Time: Sun Aug 20 10:39:29 CDT 2017

Total time taken to generate the page: 0.01120 seconds