I am new to this community. Hope to have a great learning experience here.
The error I am receiving while loading a huge file is:
SQL*Loader-510: Physical record in data file is longer than the maximum(1048576)
Actually the csv file I am loading from is huge, has 9lac+ records. Increasing the readsize doesnt help... Let me write down the full command I am issuing:
C:>sqlldr "test/test@conf" control='E:control_location.ctl',log='E:log_location.log',data='E:data_location.txt',errors=0,direct=true,commit_discontinued=true,readsize=3000000;
returns an error...
LRM-00104: '3000000;' is not a legal integer for 'readsize'
Please suggest me a way out. Thank you all in advance,
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!