• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

getting error with sqlloader

I trying to upload a flat file separated by " , " and getting below error. I have check the mappings two time.


Commit point reached - logical record count 22
Commit point reached - logical record count 44
Commit point reached - logical record count 66
0
nirvairghuman
Asked:
nirvairghuman
  • 4
  • 2
  • 2
  • +2
6 Solutions
 
magentoCommented:
If any of your varchar2 fields have a comma in them, the load will fail ...You would need to enclose with "" s
0
 
johnsoneSenior Oracle DBACommented:
Where is the error message?  The commit point reached are buffer commits and are informational messages, they are not errors.
0
 
nirvairghumanAuthor Commented:
Now I am getting the below error. I have checked the file name and path.


SQL*Loader-500: Unable to open file (/a01/export/lgacy.txt)
SQL*Loader-553: file not found
SQL*Loader-509: System error: No such file or directory
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
magentoCommented:
Are you sure the file is located in the working directory?
0
 
nirvairghumanAuthor Commented:
yes, I am sure.
0
 
nirvairghumanAuthor Commented:
Please help me guys, its urgent
0
 
johnsoneSenior Oracle DBACommented:
It could be permissions.

Run these 2 commands:

id
ls -l /a01/export/lgacy.txt

That should tell you the permissions, and what groups you belong to.  That should help determine if it is a permission problem.
0
 
slightwv (䄆 Netminder) Commented:
Are you sure the filename isn't:  legacy.txt
0
 
awking00Commented:
What does the following produce?
ls -l /a01/export/*.txt
0
 
nirvairghumanAuthor Commented:
Thanks a lot guys, I removed the old file and copied new legacy file after that it worked fine. I dont know what was the issue.
0
 
slightwv (䄆 Netminder) Commented:
I cannot speak for the other Experts but I have no problem is you want to have this question deleted since you seem to have resolved the problem yourself.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now