Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change the value of v$option

583441Jun 15 2007 — edited Jun 17 2007
Hi all,

Installed application shown ORA-00439, how to change the partitioning to TRUE of v$option ?

Thanks.



$oerr ora 00439
00439, 00000, "feature not enabled: %s"
// *Cause: The specified feature is not enabled.
// *Action: Do not attempt to use this feature.


SQL> select * from v$option where parameter like 'Partit%';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Partitioning
FALSE



SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for HPUX: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production



Try to set but failed.
SQL> alter system set Partitioning = 'TRUE';
alter system set Partitioning = 'TRUE'
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter session set Partitioning = 'TRUE';
alter session set Partitioning = 'TRUE'
*
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2007
Added on Jun 15 2007
6 comments
4,079 views