如何解决ORA-43856:SECUREFILE LOB操作不支持的LOB类型 [英] How to troubleshoot ORA-43856: Unsupported LOB type for SECUREFILE LOB operation

问题描述

根据我正在与之交谈的Oracle服务器，相同的create table DDL语句可能成功还是失败:

Depending on the Oracle server I'm talking to, the same create table DDL statement can succeed or fail:

在服务器1上

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> create table h5basic (b blob) lob(b) store as basicfile;
Table created.

SQL> 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

在服务器2上

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> create table h5basic (b blob) lob(b) store as basicfile;
Table created.

SQL> create table h5basic$none (b blob) lob(b) store as basicfile (retention none);
Table created.

这两个服务器的版本并不完全相同，第一台服务器在Linux上运行，第二台服务器在Windows上运行，但是从这方面来看，这两者之间的区别可能是什么?感谢您提供有关解决此问题的任何提示. --DD

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

推荐答案

一些选项是:

1. 检查init.ora文件以查看db_securefile参数是否设置不同-允许的值为:{ ALWAYS | FORCE | PERMITTED | NEVER | IGNORE }(请参阅此处):只能在自动段空间管理(ASSM)表空间中创建SecureFile.

1. Check the init.ora file to see if the db_securefile parameter is set differently - allowable values are: { ALWAYS | FORCE | PERMITTED | NEVER | IGNORE } (See here for more details).
2. Check if the tablespaces are both ASSM as (see here): A SecureFile can only be created in an automatic segment space management (ASSM) tablespace.

这篇关于如何解决ORA-43856:SECUREFILE LOB操作不支持的LOB类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！