How to drop hidden parameter from spfile using alter system command?
Hi Guys,
I have a hidden parameter _push_join_union_view set to FALSE in the spfile.
Now, I want to drop this parameter completely from the spfile.
How do I do that with the alter system command. I tried following but does not work.
alter system set _push_join_union_view=NULL scope=spfile;
alter system set "_push_join_union_view"=NULL scope=spfile;
alter system set '_push_join_union_view'=NULL scope=spfile
alter system set _push_join_union_view='' scope=spfile
alter system set '_push_join_union_view'='' scope=spfile
alter system set "_push_join_union_view"='' scope=spfile
Pl. help.
Thanks in Advance
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart