Re: BLOB or BFILE?

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 3 Jun 2004 22:19:49 +0200
Message-ID: <020401c449a8$1f20e780$c701a8c0@sys3>

I will be cautious of using bfiles to store data. rm * / del * can take your data away.

Yechiel Adar
Mehish
----- Original Message -----
From: "Hamid Alavi" <hamid.alavi_at_quovadx.com> To: "'Oracle-L (E-mail)" <oracle-l_at_freelists.org> Sent: Thursday, June 03, 2004 7:03 PM
Subject: BLOB or BFILE?

> List,
>
> I need your opinion on the case which I am working on?
>
> I have a application which connect to Oracle database(9.2.0.5) via ODBC
> connection , thru this connection application send a File(between 5 to 40
M)
> average 20 times a night then these file will be later downloaded from the
> user thru the application I have two Options as follows:
>
> 1) Store the file as BLOB into the table using store procedure to write
the
> BLOB to the table BUT I don't know how do I have to send it back to the
> application via ODBC?
>
> 2) Using BFILE and store the FILE in Database server in this case do I
have
> to COPY the file into the directory which I have define in oracle if yes
How
> do I have to COPY the file into the directory via ODBC?
>
> Finally which of these two way will be more efficient?
>
> Thanks for your help appreciate.
>
>
> Hamid Alavi
>
> Office : 818-737-0526
> Cell phone : 818-416-5095
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 03 2004 - 14:27:23 CDT