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.