Re: storing lobs as secure files - any gotchas?

From: Kevin Jernigan <>
Date: Wed, 27 Feb 2013 09:22:52 -0800
Message-ID: <>

There are no known downsides to using SecureFiles instead of BasicFiles for storing LOBs / files in Oracle Database. And, you can use direct path to load into a SecureFiles column regardless of whether it is in-line or out-of-line: see the doc here <> for more details.
-Kevin J
*Kevin Jernigan* 	(650) 607-0392 (o)
*Senior Director Product Management* 	(415) 710-8828 (m) <>
*Advanced Compression - ACO*: 	*Information Lifecycle Management* - ILM
   Advanced Row Compression 	*Temporal database* (Total Recall etc)
   Advanced LOB Compression 	*SecureFiles*
   Advanced LOB Deduplication 	*Database File System* - DBFS
   RMAN Backup Compression 	*Direct NFS Client* - dNFS
   Data Pump Export Compression 	*CloneDB*
   Data Guard Redo Network Transport Compression 	*Database Resource 
Manager* - DBRM
   Flashback Data Archive History Table Optimization 	*Continuous Query 
Notification* - CQN
*Hybrid Columnar Compression* - HCC 	*Index Organized Tables* - IOT
*Database Smart Flash Cache* 	*OISP*

On 2/27/2013 5:39 AM, Sayan Sergeevich Malakshinov wrote:
> Hi, Bob!
> Since you want to use securefile, i'm not sure that you need partitioning
> on 80k rows(except case when with "store in row" and you have a lot of
> short clobs)
> Also, afaik, you cannot use direct path insert of "Out-of-Line" clobs (
> because of lob id, lob index, etc...).
> Best regards,
> Sayan Malakshinov
> --

Received on Wed Feb 27 2013 - 18:22:52 CET

Original text of this message