| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Where to store BLOB's
Yechiel Adar,
We use option #2 (LOB segments in another tablespace). It allows faster queries of the non-LOB data in the "main" table and gives us flexibility as to storage parameters for the LOB segment(s). We also use interMedia Text to index the LOB (CLOB, in our case) column and those index segments are in yet another tablespace.
BTW, we have about 15 million CLOB documents, so we're not talking a tiny amount of data here.
Jack
-----Original Message-----
Sent: Tuesday, January 29, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L
Hello all
We are designing a new application.
This application stores files that were FTP to the clients
and keep then for resubmitting (if the user ask for them).
There are two formats:
1) Standard records whose internal format is known.
These files lets the user ask for a subset of the records, i.e. all the records for branch xxxx that were submitted in the last week, etc. . 2) Strange files that are moved as a file.
Here the application is not aware of the internal format, i.e. excel files, and these files are going to be stored as Blob's and the user can ask only for the whole file again.
I know that you can store Blob's in three ways: (already rtfm a little)
1) In the record (up to 4k), more goes to another tablespace. 2) In Oracle but in another tablespace (always). 3) As external files.
I would like to learn from your experience what is the best, easiest to implement, easiest to admin, less demanding on Oracle and all the good stuff.
TIA
Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: japplewhite_at_inetprofit.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Jan 29 2002 - 18:12:07 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |