| Error 00439 [message #174168] |
Fri, 26 May 2006 05:38  |
magnumopus01
Messages: 3
Registered: May 2006
|
Junior Member |
|
|
Hi,
when I attempt to create a partitioning Table I receve an error
message with ora-00439 the Partitioning function is not anabled..
The version of RDBMS is Ora9.2.0.4
I'have just installed the partitioning software and I'have ran the
catpart.sql... but i receive the same error...
How I can enable the partitioning function?
Thank!!!!!!!!!!!!!!
Emanuele
|
|
|
|
| Re: Error 00439 [message #174181 is a reply to message #174168] |
Fri, 26 May 2006 06:44  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
You need to upgrade to Oracle Enterprise Edition. Partitioning is only available with enterprise edition.
00439, 00000, "feature not enabled: %s"
// *Cause: The specified feature is not enabled.
// *Action: Do not attempt to use this feature. |
|
|
|
|
|
| Re: Error 00439 [message #174438 is a reply to message #174193] |
Mon, 29 May 2006 04:29 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Check if partitioning is enabled at database level as well.
Value should be true in case of enabled partitioning.
SQL> select * from v$option where parameter = 'Partitioning';
PARAMETER VALUE
-------------------------------- -------------------
Partitioning TRUE
--Girish
|
|
|
|
|
|
| Re: Error 00439 [message #175035 is a reply to message #174661] |
Wed, 31 May 2006 08:19 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Check for installed products & also the banner that you get in when logging in sql plus.
If partitioning products are installed , you should see "With the Partitioning" in the banner & also in installed products.
The only way I colud get hold of is.. to check the aforesaid things & then if needed, reinstall the partitining software.
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
