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
Post a Comment