Q
Problem solve Get help with specific problems with your technologies, process and projects.

Loading data from CSV file into Oracle table using SQL*Loader

I am trying to load data from a CSV file into my Oracle table using the SQL*Loader utility. I am new to SQL*Loader, and when I run the utility, all my records are identified as bad and the the program aborts. My requirement is that there are 5 columns which I need to default values in the control file and there are 15 columns from the CSV file. All 20 fields should be loaded as one row. Can somebody help?

Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close