Hi,

I need help on external tables.

I have created external table 1 month back and it was working that time.
after long time I tried using that table today and it was throwing an error.
even the file is not changed and the logical directory also available.
logical directory was created with the same userid.

select * from ext_table
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file EXT_TABLE_16367.log
OS error Permission denied
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

Regards,
Nandhakumar.
-----------------------------------DISCLAIMER----------------------------------------------------------------
This email is confidential. If you are not the addressee tell the
sender immediately and destroy this email without using, sending or storing
it. Emails are not secure and may suffer errors, viruses, delay,
interception and amendment. ING Vysya Bank Ltd and subsidiaries do not accept
liability for damage caused by this email and may monitor email
traffic.

--------------------------------------------------------------------------------------------------------------------------

Oracle LazyDBA home page