I have a document processing system on Oracle 10.2 Linux. It stores document as blob in the database. We store 1 Million docs a month and current table size is 5 million. Database size is 50 GB out of which blob table takes 35 GB. (It is not partitioned).
disadvantage that I should not consider it at all?
Are the BLOB's transactional in anyway, especially are they subject to change? If so then consistent recovery requirements might be overly complicated.
My personal preference for files is to store them on filesystems with a pointer to them in the DB (either a BFILE or else just a straight uri for them)
-- Niall Litchfield Oracle DBA http://www.orawin.info