Error while loading data using external tables

[sankar]

Hi All,

We are getting a daily feed data file containing numberic data, CLOB data, and also date data. I am trying to load this data using using External tables. For exaple the flat file is as follows:

7369|SMITH|THIS IS CLERK
7499|ALLEN|THIS IS SALESMAN
7521|WARD|THIS SALESMAN

Target table is EMP_TEMP(ID NUMBER(10), NAME VARCHAR2(100),JOB_DESC CLOB). I am using Oracle 9.2.0.7 running on Linux. When trying to create External tables as

CREATE TABLE
ext_emp (
EMPNO number(10), ENAME varchar2(100), JOB CLOB
)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY EMP_DIR
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY '|'
)
LOCATION('emp.txt'))
REJECT LIMIT UNLIMITED

I am getting error as "ORA-30656: column type not supported on external organized table"
Does Oracle 9i supports CLOB data types on External Tables?

Any help on how we can load data into target table CLOB columns using external tables?

[davey23uk]

you cant as it says, use sql loader instead