Home » RDBMS Server » Server Utilities » SQL Loader Error (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)
SQL Loader Error [message #670550] Thu, 12 July 2018 10:21 Go to previous message
vharish006
Messages: 67
Registered: August 2015
Location: Chicago
Member
Hi All,

I'm Trying to load data to a table from csv.

Below is the table and data type on it.

CREATE TABLE XX.XXX_XXX_XXX
(
  XX_ID     NUMBER(30),
  XX_NAME   VARCHAR2(400),
  ACTIVITY_STATUS   VARCHAR2(255), 
  ECONOMIC_MODEL     VARCHAR2(255),
  GOVERNANCE          VARCHAR2(255),
  "LEVEL"            INTEGER,
  MISSION             VARCHAR2(4000),
  NUMBER_OF_SITES     VARCHAR2(255),
  SELF_DESCRIPTION    VARCHAR2(255),
  REACH                VARCHAR2(255),
  SUBJECTS              VARCHAR2(4000));

Below is the Control File.

OPTIONS ( skip=1,BINDSIZE=12557648,READSIZE=12557648)
LOAD DATA 
INFILE 'PROQ_classifications_FULL_20180503.csv' 
INTO TABLE PQINF.RINGGOLD_IDENTIFY_SUBJECTS
TRUNCATE 
Fields Terminated    by ","   
OPTIONALLY ENCLOSED BY '"'
(RINGGOLD_ID
,RINGGOLD_NAME
,ACTIVITY_STATUS
,ECONOMIC_MODEL
,GOVERNANCE
,"LEVEL"
,MISSION CHAR(4000)
,NUMBER_OF_SITES
,SELF_DESCRIPTION
,REACH
,SUBJECTS CHAR(4000))


I'm encountering error on SUBJECTS Columns

"Field in data file exceeds maximum length"

Below is how the data looks in Subjects column.Just giving a sample as it has too much data

"Applied Sciences/Agriculture and Food/Animal Science/Fishery Science,Applied Sciences/Bioscience/Genetic Modification,Applied Sciences/Computer Science/Computer Programming/Software Development,Applied Sciences/Computer Science/Computing Information Science,Applied Sciences/Computer Science/Human Computer Interaction,Applied Sciences/Engineering/Architectural Engineering,Applied Sciences/Engineering/Chemical Engineering,Applied Sciences/Engineering/Civil Engineering,Applied Sciences/Engineering/Civil Engineering/Construction,Applied Sciences/Engineering/Civil Engineering/Engineering Infrastructure,Applied Sciences/Engineering/Electronics,Applied Sciences/Engineering/Electronics/Electronic Components and Devices,Applied Sciences/Engineering/Electronics/Electronic Components and Devices/Computer Hardware,Applied Sciences"

Please suggest if some thing needs to be added to the CTL file.

Apologize me if not not asking the question right way.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: SQL Loader Bind Size
Next Topic: ORA-39014: One or more workers have prematurely exited. ORA-31671: Worker process DW00 had an unhand
Goto Forum:
  


Current Time: Mon Mar 30 15:07:29 CDT 2020