Re: BLOB or BFILE?
- From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Jun 2004 22:19:49 +0200
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@xxxxxxxxxxx>
To: "'Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
