ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA
857439Apr 25 2011 — edited Apr 25 2011Hi,
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