Home » RDBMS Server » Server Administration » partitioning not enabled
| partitioning not enabled [message #53811] |
Sat, 12 October 2002 04:24  |
freewill
Messages: 16
Registered: October 2002
|
Junior Member |
|
|
When running this example:
CREATE TABLE sales
( invoice_no NUMBER,
sale_year INT NOT NULL,
sale_month INT NOT NULL,
sale_day INT NOT NULL )
STORAGE (INITIAL 100K NEXT 50K) LOGGING
PARTITION BY RANGE ( sale_year, sale_month, sale_day)
( PARTITION sales_q1 VALUES LESS THAN ( 1999, 04, 01 )
TABLESPACE tsa STORAGE (INITIAL 20K NEXT 10K),
PARTITION sales_q2 VALUES LESS THAN ( 1999, 07, 01 )
TABLESPACE tsb,
PARTITION sales_q3 VALUES LESS THAN ( 1999, 10, 01 )
TABLESPACE tsc,
PARTITION sales_q4 VALUES LESS THAN ( 2000, 01, 01 )
TABLESPACE tsd)
I get this error message:
ORA-00439: feature not enabled: Partitioning
I installed oracle 8.1.5 on WINDOWS2000 SERVER
.In my installing process ,I didn't have chance to select the partition feature (neither typical nor custom installation).Anyone know how to set the partitioning feature for oracle 8.1.5 please E-mail me.
Any help will be greatly appreciated.
|
|
|
|
|
|
| Re: partitioning not enabled [message #58832 is a reply to message #53814] |
Thu, 02 October 2003 18:59  |
Pablo
Messages: 7
Registered: August 2002
|
Junior Member |
|
|
you need a seperate license for partitioning option.This must be installed when you install the server.
Comment from schwertner Date: 09/12/2003 12:50AM PDT
Partitioning Option gets installed as part of the Oracle8i Enterprise
Edition, or Personal Edition, 'Typical' and Minimal' installation
options.
Partitioning Option is not a part of the Oracel8i Standard Edition.
Partitioning Option cannot be installed as part of the 'Custom'
installation option as is the case with the Oracle 8.0.X versions.
To confirm that it has been installed, check through either of these
methods:
1) Initiate the Oracle Universal Installer (OUI) and select the
'Installed Products' option. In the products listed you should see
the following path;
8.1.7: OraHome81-->Oracle Product Options-->Oracle Partitioning
8.1.6: OraHome81-->Oracle8i Enterprise-->O8iServer-->Oracle Partitioning
8.1.5: OraHome81-->Oracle8i Enterprise-->O8iServer-->SQLPLUS-->Oracle Partitioning
2) Initiate SQL*Plus and the logon banner will show:
SQL*Plus: Release 8.1.6.0.0 - Production
(c) Copyright 1999 Oracle Corporation.
Connected to:
Oracle8i Enterprise Edition Release 8.1.
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL>
3) The setting of the Partitioning parameter can also be verified in
the V$OPTION table as follows:
SQL> select * from v$option where parameter = 'Partitioning';
PARAMETER VALUE
-------------------------------- -------------------
Partitioning TRUE
Comment from schwertner Date: 09/12/2003 12:53AM PDT
Before answering the question, "How to resolve "ORA-439: Feature not enabled; Partitioning" an explanation will first be provided regarding how the partitioning option
could be installed in the database.
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.
Let's talk about these two steps in more detail.
1- Install Oracle Software with Partitioning Option
---------------------------------------------------
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.
2- Enable the Partitioning option at the Database Level.
------------------------------------------------------
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.
Comment from m_eglit Date: 09/12/2003 12:54AM PDT
It's not installed...
can Partitioning option be added manualy ??
I realy need this option ...... (client needs)
Comment from m_eglit Date: 09/12/2003 12:57AM PDT
Excellent answer... but my server located on NT ......
your recomendation *NIX Like...(Solaris ?)
Accepted Answer from schwertner Date: 09/12/2003 01:36AM PDT
No problems with Windows!
Read the following at the end:
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.
Comment from schwertner Date: 09/12/2003 01:38AM PDT
It can be installed manually if it exists on the Installer CD ROM, i.e. if you have Enterprise Edition.
If you have not this CD, download it from the OTN.
|
|
|
|
Goto Forum:
Current Time: Fri Sep 20 08:44:43 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
