title: How to troubleshoot ORA-43856: Unsupported LOB type for SECUREFILE LOB operation
body: <p>Depending on the Oracle server I'm talking to, the same create table DDL statement can succeed or fail:</p>
  
  <p>On Server#1</p>
  
  <pre><code>Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
  With the Partitioning, OLAP, Data Mining and Real Application Testing options
  
  SQL&gt; create table h5basic (b blob) lob(b) store as basicfile;
  Table created.
  
  SQL&gt; create table h5basic$none (b blob) lob(b) store as basicfile (retention none);
  create table h5basic$none (b blob) lob(b) store as basicfile (retention none)
  *
  ERROR at line 1:
  ORA-43856: Unsupported LOB type for SECUREFILE LOB operation
  </code></pre>
  
  <p>On Server#2</p>
  
  <pre><code>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  With the Partitioning, OLAP, Data Mining and Real Application Testing options
  
  SQL&gt; create table h5basic (b blob) lob(b) store as basicfile;
  Table created.
  
  SQL&gt; create table h5basic$none (b blob) lob(b) store as basicfile (retention none);
  Table created.
  </code></pre>
  
  <p>The two servers are not exactly the same version, and the first runs on Linux while the second on Windows, but appart from that, what could be different between the two to explain this difference in behavior? Thanks for any tips in troubleshooting this issue. --DD</p>