OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL Loader Error (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader Error [message #670550]

Thu, 12 July 2018 10:21

vharish006
Messages: 70
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.

Report message to a moderator

[Message index]

		SQL Loader Error By: vharish006 on Thu, 12 July 2018 10:21
		Re: SQL Loader Error By: Michel Cadot on Thu, 12 July 2018 10:28
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 10:51
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 11:00
		Re: SQL Loader Error By: Michel Cadot on Thu, 12 July 2018 11:02
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 11:06
		Re: SQL Loader Error By: Michel Cadot on Thu, 12 July 2018 11:11
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 11:26
		Re: SQL Loader Error By: Michel Cadot on Thu, 12 July 2018 11:32
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 11:34
		Re: SQL Loader Error By: Michel Cadot on Thu, 12 July 2018 11:51
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 11:57
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 12:06
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 12:13
		Re: SQL Loader Error By: vharish006 on Thu, 12 July 2018 12:58
		Re: SQL Loader Error By: Michel Cadot on Thu, 12 July 2018 11:09

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 11:32:01 CDT 2024