How to create a directory alias on Suse Linux7.3 to insert an external PDF file into BFILE column.

From: Meomeo Nguyen <meomeo22_at_yahoo.com>
Date: Tue, 17 Sep 2002 08:58:30 -0800
Message-ID: <F001.004D1721.20020917085830@fatcity.com>

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Meomeo Nguyen
  INET: meomeo22_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Sep 17 2002 - 11:58:30 CDT