ORA-00439: función no activada: Partitioning

To Use the Partitioning Option in your Database, it's required to:
1- Install the Oracle Software with the Partitioning Option.
2- Enable the Partitioning option at the Database Level
When you Install Oracle Server - Enterprise Edition (or Personal Edition)
Software you have the option to include/exclude Partition option. By default
'Typical' and Minimal' installation options have it enabled, but sometimes
one may choose not to install it when installing the software. When you
choose to install the Partition Option, the Oracle installer will copy the
object files related to the partition option to $ORACLE_HOME/rdbms/lib and
then relink the oracle executable.
To verify if the Partitioning option has been installed, do the following
- Initiate the Oracle Universal Installer (OUI) and select the 'Installed Products'
Option. In the products listed you should see the following path:
-->OraHome817-->Oracle Product Options-->Oracle Partitioning
This may vary between different versions.
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
If it is not enabled in the database then do the following step:
- 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
How to resolve the "ORA-439: Feature not enabled; Partitioning" error:
----------------------------------------------------------------------
You may get this error in different situations. Here we will try to list all
possible situations and how to resolve each one.
1- You have Oracle 8.1.7.0.0 (or any base version of the software) and partition
option was not installed when you installed Oracle Server - Enterprise Edition
Software.
In this situation you should get the Installation CD and install the Partitioning Option
only. After installing the software successfully, go to the database
and establish a connection. Check to see if the Partitioning option is enabled
in the v$option view and in the banner upon connection.
If it is not enabled in the database then do the following:
- 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
- Startup the database and check the value for partitioning option in the
v$option view, it should be TRUE now
2- You have Oracle 8.1.7.0.0 (or any base version of the software) and partition
option was installed when we installed Oracle Server - Enterprise Edition
Software, but the value for Partitioning option in the v$option view is false.
In this situation we should do the following
- 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
- Startup the database and check the value for partitioning option in the
v$option view, it should be TRUE now
3- You have installed Oracle 8.1.7.3.0 patchset (or any patchset on any version
of the software) and the partitioning option was not installed when installing
Oracle Server - Enterprise Edition 8.1.7.0.0 Software.
In this situation we can't install the Partitioning Option from the Installation
CD because the version of option will be 8.1.7.0.0 while our other
software and database version is 8.1.7.3.0. So, the version mismatch may cause
future problems. The best way to solve this problem is to reinstall the Oracle
software version 8.1.7.0.0, with Partitioning option selected and then reinstall
the 8.1.7.3.0 patchset.
After we reinstall the software and the patchset, we should go to the database
and connect to verify the Partitioning option is enabled in v$option and in the
banner.
If it is not enabled in the database then do the following:
- 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
- Startup the database and check the value for partitioning option in the
v$option view, it should be TRUE now
4- You have installed Oracle 8.1.7.3.0 patchset (or any patchset on any version
of the software) and partitioning option was installed when we installed Oracle
Server - Enterprise Edition 8.1.7.0.0 Software. However, the Partitioning option
in v$option (value) is FALSE
In this situation we should do the following:
- 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
- Startup the database and check the value for partitioning option in the
v$option view, it should be TRUE now
Known Issues
===============
1- If you tried to enable partition option using the "make -f ins_rdbms.mk part_on"
command without installing the partitioning option from the Installation CD first you
will get the following error:
$ make -f ins_rdbms.mk part_on
make: Fatal error: Don't know how to make target `/u04/oracle/product/8.1.7/
rdbms/lib/kkpoban.o'
2- You can Install the Partitioning option from the software CD and disable it in the
database:
Example :
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_off
$ make -f ins_rdbms.mk ioracle
Then Startup the database and check the value for partitioning option in the
v$option view, it should be FALSE now, and you will not see the partitioning option
displayed in the banner when you connect to the database
3- 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.
The above situations/solutions will work for Oracle software installed
on the Windows operating system patforms, except the relink step doesn't apply
saludos.
Note tomada de metalink