Skip to Main Content

SQL & PL/SQL

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!

ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA

857439Apr 25 2011 — edited Apr 25 2011
Hi,
i am using external tables for fetching values from text file
1)
create or replace directory XTERN_DATA_DIRTEST
as 'E:\test';

2)
create table xtern_countrytest
(
COUNTRYNAME VARCHAR2(200)
)
organization external
( default directory XTERN_DATA_DIRtest
access parameters
(
records delimited by '|$|'
fields terminated by '|#|'
MISSING FIELD VALUES ARE NULL
)
location ('Country.txt')
)

when i execute

select * from xtern_countrytest am gettng following error

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Country.txt in XTERN_DATA_DIRTEST not found
ORA-06512: at "SYS.ORACLE_LOADER", line 19

FYI,i have granted access,file is present at location,same thing works in development environment,but this error is happening in live server,
can any one has a idea about this,its urgent
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2011
Added on Apr 25 2011
4 comments
688 views