Re: storing lobs as secure files - any gotchas?

From: Kevin Jernigan <kevin.jernigan_at_oracle.com>
Date: Wed, 27 Feb 2013 09:22:52 -0800
Message-ID: <512E40EC.7050002_at_oracle.com>

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_at_oracle.com <mailto:kevin.jernigan_at_oracle.com>
*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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

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