Database Utilities (MOSC)

MOSC Banner

Sql loader Tab delimted data not loading

edited May 8, 2016 5:02AM in Database Utilities (MOSC) 12 commentsAnswered

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"

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center