I have an external table defined as follows:
CREATE TABLE EXT_MASTER
( "SOME_CODE" VARCHAR2(255 BYTE),
"FAX_NUMBER" VARCHAR2(255 BYTE),
"WEB_ADDRESS" VARCHAR2(255 BYTE),
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "SOME_DIR"
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
NODISCARDFILE
LOGFILE 'master.log'
BADFILE 'global.bad'
SKIP 1
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LRTRIM
MISSING FIELD VALUES ARE NULL
)
LOCATION
( 'Master.csv'
)
)
REJECT LIMIT UNLIMITED;
In my datafile I have newline characters within double quotes. This seems to be illegal using the above definition for the table.
Is there a way to make Oracle ignore newline characters in csv files when they are enclosed in double quotes? Or should I ask my data provider to remove them?