Bfile or BLOB
780914Jul 14 2010 — edited Jul 15 2010Despite of earlier similar threads in the forum, I initiate this thread to indentify the scenarios where it is beneficiary to use BFILE and not BLOB.
I understand the difference between the two as BFILE is external LOB and only stores the location path reference but BLOB physically stores the file. Then my question is "Is it similar to storing location path as string value instead of storing ref in BFILE. Using path string, file from it can be fetched using utl_file/JAVA side". And also, how would I decode that whether I have to use BLOB or BFILE in some situation. Please suggest with help of some scenarios.
I am using Oracle 11gR2. If any other related info is required, kindly let me know.
Edited by: SBH on Jul 14, 2010 1:42 AM