SELECT EXTERNAL TABLE error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SELECT EXTERNAL TABLE error

  1. #1
    Join Date
    Oct 2002
    Location
    CA
    Posts
    67

    SELECT EXTERNAL TABLE error

    Hi There,
    Env: Solaris 9, Oracle 9i

    I have a sql script that creates a table fine but fails on select *.
    In Unix, I grant all permission for my directory, /export/home/james'.
    Any advise?

    SQL> select count(*) from deadholding_ext;
    select count(*) from deadholding_ext
    *
    ERROR at line 1:
    ORA-29913: error in executing ODCIEXTTABLEOPEN callout
    ORA-29400: data cartridge error
    KUP-04063: unable to open log file ext.log
    OS error Permission denied
    ORA-06512: at "SYS.ORACLE_LOADER", line 14
    ORA-06512: at line 1


    Here is my sql:
    --------------
    drop DIRECTORY james_data;
    CREATE DIRECTORY james_data AS '/export/home/james';
    drop table deadholding_ext;
    CREATE TABLE deadholding_ext
    (deadholding_pidm number(8),
    deadholding_id varchar(9),
    deadholding_LName varchar(60),
    deadholding_Fname varchar(15),
    deadholding_MName varchar(15),
    deadholding_Date date)
    ORGANIZATION EXTERNAL
    (
    TYPE ORACLE_LOADER
    DEFAULT DIRECTORY james_data
    ACCESS PARAMETERS
    (
    records delimited by newline
    badfile james_data:'ext.bad'
    logfile james_data:'ext.log'
    fields terminated by ','
    missing field values are null
    ( deadholding_pidm, deadholding_id, deadholding_LName, deadholding_FName, deadholding_MName,
    deadholding_Date char date_format date mask "dd-mon-yyyy"
    )
    )
    LOCATION ('boyDead.csv')
    )
    PARALLEL
    REJECT LIMIT UNLIMITED;
    ----------------
    Unix Permission:
    james@bmssun2./export/home/james>ls -lt
    total 1148
    drwxrwxrwx 2 james staff 512 Jun 2 14:05 data
    --------------------------------------
    It's not what the world does to you that matters. It's how you respond...

  2. #2
    Join Date
    Oct 2002
    Location
    CA
    Posts
    67
    I get it working after doing some more research.

    Basically I need to create 'external_tables' directory, and under it create log and bad dirs.
    --------------------------------------
    It's not what the world does to you that matters. It's how you respond...

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