00439, 00000, "feature not enabled: %s"
// *Cause: The specified feature is not enabled.
// *Action: Do not attempt to use this feature.
To Verify if the Partitioning Option is enabled in the Database, do the following:
- Initiate SQL*Plus and the logon banner will show:
SQL*Plus: Release 8.1.7.0.0 - Production
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL>
- The status of the Partitioning Option can also be verified in the V$OPTION
view as follows:
SQL> select * from v$option where parameter = 'Partitioning';
PARAMETER VALUE
--------------------- -------------------
Partitioning TRUE
만약 False일경우 해결방법(for Unix platform)
- Shutdown all databases that use this ORACLE_HOME
- Run the following
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on
$ make -f ins_rdbms.mk ioracle
기타사항
1. 초기설치시 partitioning option 을 설치하지 않고 patchset을 설치했을 경우 installation CD로 부터 설치 할 수 없다.
Oracle software제거후 partitioning option으로 재설치해야 한다.
2. With Oracle installationds on Windows, the concept of relinking doesn't exist.
When you install the Partitioning option from the software CD, it will enable it
automatically at the database level. There is no option to have the partitionING
option installed from the software, and not enabled at the database. However, this
is possible on Unix platforms.