hi,
I'm working with oracle 10.2.0. I should create an external table linked to a remote directory (\\ASserver\e$\PDF).
first, I mapped the remote directory to a network drive (say W). I have full access to W:\ folder from DB server. Also, I gave full control right to everyone to PDF folder.
then, I created a DB directory
CREATE OR REPLACE DIRECTORY EXT_PDF_DIR AS 'W:\';
finally, I created my external table
CREATE TABLE EXT_TAB_PDF
(
FILENAME VARCHAR2(300),
PDF BLOB
)
ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY EXT_PDF_DIR
ACCESS PARAMETERS (RECORDS DELIMITED BY NEWLINE
NOLOGFILE
FIELDS TERMINATED BY ';' (FILENAME CHAR(300))
COLUMN TRANSFORMS (PDF FROM LOBFILE(FILENAME)))
LOCATION ('FILE_EXT_PDF.DAT'))
that worked, but I can not read data in my table, because of this error
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file FILE_EXT_PDF.DAT in EXT_PDF_DIR not found
ORA-06512: at "SYS.ORACLE_LOADER", line 19
It looks like DB is not able to access the remote directory W. I tried the same operations on an internal directory, and everything works.
What must I do to make the DB be able to access and read the remote folder?
thanks for your help