select * from v$option ;
PARAMETER VALUE
Partitioning FALSE
检查数据库版本,必须要是企业版:
select * from v$version;
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
启用Partitioning属性一下:
SQL> shutdown immediate;
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on
$ make -f ins_rdbms.mk ioracle
SQL>startup
重新检查Partitioning状态,结果为TRUE,正确。
PARAMETER VALUE
Partitioning FALSE
检查数据库版本,必须要是企业版:
select * from v$version;
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
启用Partitioning属性一下:
SQL> shutdown immediate;
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on
$ make -f ins_rdbms.mk ioracle
SQL>startup
重新检查Partitioning状态,结果为TRUE,正确。