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" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "oraora oraora" <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
