Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: BLOB or BFILE?
Unless you're on an older version of database(meaning 8i), incremental
exports have bene deprecated in version 9.0.x. meaning you can't do
incremental exports in version 9.
joe
(DAMN QUOTING, BAH GOT ME AGAIN, REPOST)
ORIGINAL MESSAGE BELOW
I have to keep the data for 6 month and each night we have to run an
incremental export which I think could be slow.
BTW you mentioned using staging table then write it on database server
by using UTL_FILE can we do this at some other then removing it from
staging table or not?
Do you have a sample code for using UTL_FILE
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent: Thursday, June 03, 2004 12:28 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: BLOB or BFILE?
Hamid
Hopefully someone who has used the BFILE will respond to your
posting. My
suspicion is that a lack of replies indicates a lack of usage.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hamid Alavi
Sent: Thursday, June 03, 2004 12:04 PM
To: 'Oracle-L (E-mail)
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:
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
-- 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:54:15 CDT
![]() |
![]() |