check the grant for the directory being used, ie that the user you are
trying to read the external table with has been granted read on the
directory in dba_directories.
Luis
-----Original Message-----
From: nandhakumars
[mailto:oracledba-ezmlmshield-x94636338.[Email address protected]
Sent: 31 August 2007 11:27
To: LazyDBA Discussion
Subject: Error in External table.
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.
------------------------------------------------------------------------
--------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com
Oracle LazyDBA home page