Skip to Main Content

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 ERROR

user12121820May 31 2014 — edited Jun 2 2014

Hi ,

I am using below extrenal table script

CREATE TABLE emp_load

     (employee_number      VARCHAR2(50),

      employee_last_name   VARCHAR2(50),

       employee_first_name  VARCHAR2(50),

      employee_middle_name VARCHAR2(50),

       employee_hire_date   VARCHAR2(50))

    ORGANIZATION EXTERNAL

      (TYPE ORACLE_LOADER

      DEFAULT DIRECTORY ABC_LOAD

      ACCESS PARAMETERS (FIELDS TERMINATED BY '|'

        RECORDS DELIMITED BY NEWLINE

        MISSING FILED VALUES ARE NULL

         (employee_number      VARCHAR2(50),

      employee_last_name   VARCHAR2(50),

       employee_first_name  VARCHAR2(50),

      employee_middle_name VARCHAR2(50),

       employee_hire_date   VARCHAR2(50))

       )         

      LOCATION ('info.dat')

     ) REJECT LIMIT UNLIMITED;

and have created a directory ABC_LOAD as "C:\Oracle" and my os is WINDOWS 8.

and the content of my .DAT file is

010|ABC|DEF|XYZ|03-DEC-2011

but when i doing select * from emp_load i am getting below error.

ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-00554: error encountered while parsing access parameters

KUP-01005: syntax error: found "records": expecting one of: "column, enclosed,

(, ltrim, lrtrim, ldrtrim, missing, notrim, optionally, rtrim, reject"

KUP-01007: at line 2 column 9

I am using Oracle 11g R2 and Windows as OS.

Any help please.

Thanks.

This post has been answered by Solomon Yakobson on May 31 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 28 2014
Added on May 31 2014
2 comments
1,349 views