| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Best way to store images in DB ?
UTL_FILE_DIR is for text files only using utl_file package; not useful for
pictures.
For pictures you have two choices
(1) Use BLOB fields where the picture can be stored in the database. This adds to security and reliability. However, it generates too much redo (and archvive).
(2) Use BFILE, where the actual file is stored on the file system and pointer to it is stored in the database. However security is definitely an issue. And how do you plan to back it up?
There are other ways like using WebDAV and iFS, but I have no experience in using them.
HTH
Arup Nanda
www.proligence.com
>From: "oraora oraora" <oraoraora_at_rediffmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Best way to store images in DB ?
>Date: Tue, 26 Nov 2002 19:14:20 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc5-f20.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 26 Nov
>2002 20:03:52 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id TAA59053;Tue, 26 Nov 2002 19:58:40 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050D1CD;
>Tue, 26 Nov 2002 19:14:20 -0800
>Message-ID: <F001.0050D1CD.20021126191420_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "oraora oraora" <oraoraora_at_rediffmail.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>Return-Path: root_at_fatcity.cts.com
>X-OriginalArrivalTime: 27 Nov 2002 04:03:52.0570 (UTC)
>FILETIME=[FF66FDA0:01C295C9]
>
>Lee,
>
>i have to store 20,000,000 images of 5k each in DB.
>which is the best possible way to do it ?
>can i store it as BLOB or use UTL_FILE_DIR ?
>is there any other means of achieving the same ?
>
>it's 8.1.6 on Win2k.
>
>Kindly let me know.
>
>TIA.
>Jp.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: oraora oraora
> INET: oraoraora_at_rediffmail.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: arupnanda_at_hotmail.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 Nov 26 2002 - 22:18:48 CST
 |
 |