Re: storing lobs as secure files - any gotchas?

  • From: Kevin Jernigan <kevin.jernigan@xxxxxxxxxx>
  • To: malakshinovss@xxxxxxxxx
  • Date: Wed, 27 Feb 2013 09:22:52 -0800

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 
<http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_managing.htm#i1009749>
 
for more details.
-Kevin J

*Kevin Jernigan*        (650) 607-0392 (o)
*Senior Director Product Management*    (415) 710-8828 (m)
kevin.jernigan@xxxxxxxxxx <mailto:kevin.jernigan@xxxxxxxxxx>
*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
> http://orasql.org
>
> --
> //www.freelists.org/webpage/oracle-l
>
>



--
//www.freelists.org/webpage/oracle-l


Other related posts: