Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External table is not accepting more than 255 Characters

718213Aug 21 2009 — edited Aug 21 2009

Hi,

I'm new to External table.. Somehow External table is not accepting more than 255 Characters even though I'm using VARCHAR2(4000 BYTES).. Can you please help me..

CREATE TABLE DM_CL_ExterTbl_Project
(
project_name VARCHAR2(80 BYTE),
project_id VARCHAR2(20 BYTE),
work_type VARCHAR2(100 BYTE),
work_description VARCHAR2(4000 BYTE)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY UTL_FILE_DIR
ACCESS PARAMETERS
(
records delimited by '#(_@p9#' SKIP 1
logfile 'pp.log'
badfile 'pp1.bad'
fields terminated by ','
OPTIONALLY ENCLOSED BY '"' and '"'LDRTRIM
missing field values are null
REJECT ROWS WITH ALL NULL FIELDS
(
project_name,
project_id,
work_type,
work_description
)
)
LOCATION (UTL_FILE_DIR:'TOG_Data_Extract.csv')
)
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING

Thanks in advance..

~~Manju