How to drop hidden parameter from spfile using alter system command?

[samdba]

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

[davey23uk]

alter system reset .....

[mahajanakhil198]

The parameters can't be dropped. They can be reset to a default value.

[samdba]

Hi,

Ours is a Non-RAC environment. But, still following statement worked.

alter system reset "_push_join_union_view" scope=spfile sid='*';

I wonder if there are any other alternates available.

Thanks,

Sam

[davey23uk]

why an alternate to the command that does what is supposed to do?

[samdba]

why an alternate to the command that does what is supposed to do?

The above command is supposed to be for RAC system and ours is Non-RAC system. So, I am wondering if there is a similar command for Non-RAC system as well.

Thanks for your help.

[PAVB]

The above command is supposed to be for RAC system

... who told you that?

[davey23uk]

The above command is supposed to be for RAC system and ours is Non-RAC system. So, I am wondering if there is a similar command for Non-RAC system as well.

Thanks for your help.

totally not true at all