| 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)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
