How to change the value of v$option
583441Jun 15 2007 — edited Jun 17 2007Hi 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