| sql loader issue [message #158558] |
Mon, 13 February 2006 03:28  |
kdastageer
Messages: 28
Registered: January 2006
Location: Qatar
|
Junior Member |
|
|
Hi,
How much the limitation of flat file rows to load by sql loader.
Because i am having one flat file having more than 1 crore when i try to load it showing error could not read or open the control file.
Please help me..
Thanks.
|
|
|
|
| Re: sql loader issue [message #158592 is a reply to message #158558] |
Mon, 13 February 2006 06:26  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> Because i am having one flat file having more than 1 crore when i try to load it showing error could not read or open the control file.
Always,
Post the error.
Post your versions,command line etc.
In this case, it seems that your controlfile is NOT visible to sqlldr.
did you name it properly ?
The most frequent newbie mistake is to edit the mycontrolfile.ctl in windows notepad and save it as mycontrolfile.ctl.txt.
Sqlldr will be looking for mycontrolfile.ctl
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
