Error while loading data using external tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error while loading data using external tables

  1. #1
    Join Date
    Oct 2004
    Posts
    18

    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?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  



Click Here to Expand Forum to Full Width