One record spiltted into different lines in sql loader -


i trying create table in oracle express in local database. while importing data, facing issues of records appear in more 1 line. used here /n start new line. feel /n there in between data taking 1 record different records. used follwoing query

organization external ( type oracle_loader  default directory ext_tab_dir access parameters ( records delimited '\n' characterset 'utf8' badfile 'sod_rule_set_bad.txt'  logfile 'sod_rule_set_log.txt'  skip 1 fields terminated ',' optionally enclosed '"' missing field values null  reject rows null fields  )  location ('sod_rule_set.csv') 

can know how make 1 records in 1 line, getting broke up.

i found answer

organization external ( type oracle_loader  default directory ext_tab_dir access parameters ( records delimited '\r\n' characterset 'utf8' badfile 'sod_rule_set_bad.txt'  logfile 'sod_rule_set_log.txt'  skip 1 fields terminated ',' optionally enclosed '"' missing field values null  reject rows null fields  )  location ('sod_rule_set.csv') 

Comments