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