Hi ,
i am trying to read the tab separated data in csv file from external table but it is considering as single line instead of considering as multiple lines after gave the "records delimited by newline" access parameter . please help on this .
First line is header and second line is real data
Sample Data :
id greffeNum greffeMillesime affaireDeno affaireType affaireNatureDemande affaireEtat affaireDate tiersNum tiersNom tiersRole adresseL1 adresseL2 adresseL3 codePostal ville siren intervenantRole intervenantNom intervenant2Role intervenant2Nom dateMaj
a1eb9802fc8497b6b816ba015ecd042f 7702 2017 SN SOCIETE GENERALE / MME COUTHURES LAURENCE F 270 EC 2017-01-02 0 SNh SOCIETE GENERALE D 29 BOULEVARD HAUSSMANN 75009 PARIS 552120222 D SCPh MALPEL & ASSOCIES 2017-02-08 16:23:10
External Table script :
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY KAIROS
ACCESS PARAMETERS
( records delimited by newline
badfile KAIROS:'COURT_ACTION_INFO.bad'
logfile KAIROS:'COURT_ACTION_INFO.log'
fields terminated by 0X'09'
missing field VALUES are NULL
)
LOCATION
( KAIROS:'ctx_creddel_20180308.csv'
)
)
REJECT LIMIT UNLIMITED