Ora-2096 Setting Hash_join_enabled scope=SPFILE
Hi,
I can change the setting for hash_join_enabled in Oracle 9.2.0.5 (Windows 2003)
Server ORA_SERVER con Oracle Version 9.2.0.5.0
SQL> alter system set hash_join_enabled=true scope=spfile ;
System altered.
SQL> select NAME, VALUE, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter where name = 'hash_join_enabled';
NAME=hash_join_enabled
VALUE=TRUE
ISSES_MODIFIABLE=TRUE
ISSYS_MODIFIABLE=FALSE
In my Db 9.2.0.5 hash_join_enabled is already TRUE
But I've tried in two Oracle 9.2.0.1 (windows 2000) one with hash_join_enabled=true the other with hash_join_enabled=false. In both cases I received the error:
alter system set hash_join_enabled=true scope=spfile
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option
Can it be a Bug or am I doing something wrongly?
Thanks in advance