ora-00439 未启用 bit-mapped indexes

1.原因

Bitmap Indexes 只有企业版中可以使用，且默认是开启的。

2.查询已安装ORACLE服务版本

select * from v$version

标准版输出：

1    Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
2    PL/SQL Release 11.2.0.1.0 - Production
3    "CORE    11.2.0.1.0    Production"
4    TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
5    NLSRTL Version 11.2.0.1.0 - Production
 

企业版输出：

SQL> select * from V$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g *Enterprise Edition* Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

3.如何升级SE到EE

1. Install the EE software in a new home.
3. Unset any Oracle environment variables.
4. Shut down the db and take a cold backup.
5. Use oradim - delete -sid <sid> to delete the old service.(if on windows)
6. use oradim -new -sid .... to create a new service.(if on windows)
7. startup upgrade and run the script files like catupgrade.sql/utlrp.sql.
8.Take a cold backup.

官方升级指导链接

4.参考

How to set the option Bit-mapped indexes to true ? — oracle-tech
Indexes and Index-Organized Tables - 11g Release 2 (11.2)