OraFAQ Forum: Server Utilities » SQLLDR80 Insertion problem

Home » RDBMS Server » Server Utilities » SQLLDR80 Insertion problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLLDR80 Insertion problem [message #613342]

Mon, 05 May 2014 04:33

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)

Report message to a moderator

Re: SQLLDR80 Insertion problem [message #613345 is a reply to message #613342]

Mon, 05 May 2014 05:01

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste the loader log file.

Report message to a moderator

Re: SQLLDR80 Insertion problem [message #613359 is a reply to message #613345]

Mon, 05 May 2014 09:07

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/

Report message to a moderator

Previous Topic:	how to handle nulls for date field in control file
Next Topic:	schema import using impdp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 17 07:08:53 CDT 2025