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