| How to Access local file residing at client from DB Server [message #532545] |
Wed, 23 November 2011 05:41  |
skm_inn
Messages: 14
Registered: January 2009
Location: New Delhi
|
Junior Member |
|
|
Hi,
I have a requirement to read flat text file(around 15000 lines) residing at a client location from DB server and write into a table in One cell.
I tried UTL_FILE and DBMS_LOB but, i am not able to access client location to read the file as it reads path from Oracle Directory.
eg.
my client path is 198.168.1.1 and my DB server is in unix say 192.168.1.10.
file location is: \\192.168.1.1\share\abc.txt
So I created One Oracle directory as MY_DIR having DIRECTORY_PATH as '\\192.168.1.1\share\'.
But both UTL_FILE and DBMS_LOB is not able to access the file.
Error Message:
-------------
Unable to process CLOB -22288 ~ ORA-22288: file or LOB operation FILEOPEN
failed
No such file or directory
Few Details for reference:
-------------------------
File Location: \\192.168.1.1\share\abc.txt
Unix DB Server location: 192.168.1.10
Table : Test (filename varchar2(30), Content CLOB)
Oracle Dir: MYDIR
Directory_Path: \\192.168.1.1\share\
Please provide some solution.
Regards,
Sujit
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
