Database Utilities (MOSC)

MOSC Banner

SQL TO ORACLE LOADING

edited Oct 21, 2015 10:05AM in Database Utilities (MOSC) 2 commentsAnswered

Hello all ,

I am loading the sql data into oracle using sqlldr. the first step what I am doing is that I am doing BCP which converts sql data to oracle data file. Now from oracle data file I am trying to load the data into the table.Now when I am running the sqlldr script only 1500 rows of data is loading from 25000 rows of data. when  checked in the log file I am getting an error stating:

Record 59: Rejected - Error on table TEST, column Name.

ORA-12899: value too large for column Name(actual: 4792, maximum: 4000)


I have also changed the data size in .CTL file to char(8000). Still I am getting the same error. SO is there any solution to this to get loaded.Thanks ask me for any questions I am not clear.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center