- Check the control file is present
- Check the data file present
- Check the data file size is zero or not
- Put dos2unix <filename> is used to remove newline character and control character , this is optional
- Load the data into custom table using sql loader
sqlldr “db_user/db_passwd” control="controlfile path".ctl log="logfilepath".log bad="badfile path".bad data="data file path“
Example :
sqlldr ${FCP_LOGIN} control="controlfile.ctl" log="logfile.log" bad="badfile.bad" data="datafile“
Note : bad file is created only data file having invalid data content
No comments:
Post a Comment