Hi,

I just wanted to create a directory alias on SuSe Linux7.3 in order to insert an external PDF file into BFILE column.  Anyone please show me how to do so.

On Window:

CREATE or REPLACE DIRECTORY TEST as 'c:\images' ;

On Linux: I issues this below command

CREATE or REPLACE DIRECTORY TEST as '/Disk05/images' ;

When using DBMS_LOB.fileexiststs function to test the existence of the file, but the specified fiel does not exist, Fileexists return zero.

please note that I've already stored a specified file on /Disk05/images. 

Thanks in advance

Lenka



Do you Yahoo!?
Yahoo! News - Today's headlines

Reply via email to