Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> 9.2.0.5+ prevents external tables reading from hard/symbolic link

9.2.0.5+ prevents external tables reading from hard/symbolic link

From: Luis Fernando Cerri <lfcerri_at_gmail.com>
Date: Tue, 9 Jan 2007 19:47:27 -0200
Message-ID: <329b3afe0701091347q3fce6fe9tb7bae89c7f2e7f2@mail.gmail.com>


Hello, list.

Starting in version 9.2.0.5 it is no longer possible to create a external table reading from a file that is a hard or symbolic link (*nix) or an UNC path (win). If you try to do that, you will get a error stack like:

SQL> select * from ext_link;
select * from ext_link
*
ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04001: error opening file /path/link_to_file.txt
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

Although it is easy to overcome by changing OS routines, I'd like to know if someone here have already figured out this puzzle by setting an special event or undocumented parameter. If yes, do you feel comfortable to use it in a production environment?

Best regards,
Luis

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 09 2007 - 15:47:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US