-
Error while loading data using external tables
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?
-
you cant as it says, use sql loader instead
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|