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

Problems loading data with SQL*Loader

I'm trying to load data into a one-column table using SQL*Loader. The column length is a varchar2(550), but sqlldr rejects data because of "Field in data file exceeds maximum length." But if I insert rows using a query INSERT INTO ... VALUES('... ') it works! What is going on?

The most common cause of this problem is due to whitespace that you can't see. Are you sure that you don't have spaces at the end of the line before the NEWLINE code?

For More Information


Dig Deeper on Oracle database design and architecture

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