Hi
I have created external tables, to read the data from csv files.
in csv file, i have columns of 350 columns and 2644 records.
when i am retrieving data from csv file, i can able to retrieve only 217 columns and records count would be 7767.
i am unable to resolve the issue or re-create the issue. can any one please suggest.
CREATE TABLE EXT_TABLE (
text clob
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY INPUT_DIR
ACCESS PARAMETERS
(
records delimited by newline
badfile INPUT_DIR:'po%a_%p.bad'
logfile INPUT_DIR:'po%a_%p.log'
fields LRTRIM REJECT ROWS WITH ALL NULL FIELDS (text char(32000))
)
LOCATION ('RvData.csv')
) ;
select count(0) from EXT_TABLE;
7767.
Excel sheet records
2644 rows
350 columns