mismatch in number of columns in table definition and csv file.
I have some ten coulumns defined in my table. I have to load data from CSV file to the table using sql loader. But there are 11 columns in my csv file and the extra column comes in the middle of the csv file. Please let me know how to skip this column while data other than modifying the csv file.
Just specify each desired column on control file.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Filler it up.
Maybe if you check the fine OracleŽ Database Utilities manual, you would find the solution in the "FILLER" option.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Click Here to Expand Forum to Full Width