Sql loader Tab delimted data not loading
Oracle 11g
Issue : Table delimited file
Control file :
load data
infile 'MDM_Extract_ADDRESS_MV_20160423_2.txt'
BADFILE 'MDM_Extract_ADDRESS_MV_20160423_2.bad'
DISCARDFILE 'MDM_Extract_ADDRESS_MV_20160423_2.dsc'
append
into table THY_CC_MDM_ADDRESS_MV
FIELDS TERMINATED BY X'09'
(ADMIN_CLIENT_ID,
ADMIN_SYSTEM_TYPE,
PERSON_ORG_CODE,
PARTY_ID,
ADDRESS_TYPE,
ADDRESS_LINE_1,
ADDRESS_LINE_2,
ADDRESS_LINE_3,
CITY,
STATE_CODE,
COUNTRY_CODE,
POSTAL_CODE,
PREFERRED_ADDRESS_INDICATOR,
DEL_DESIGNATOR,
ADDRESS_STANDARD_INDICATOR,
START_DATE,
LAST_UPDATE_DATE,
ADMIN_SYSTEM_TYPE_VAL,
STATE_CODE_VAL,
COUNTRY_CODE_VAL,
ADDRESS_TYPE_VAL)
Table struc
1. "THY_CC_MDM_ADDRESS_MV"