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

alter system reset .....

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

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

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

Quote:

---

Originally Posted by davey23uk

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.

Quote:

---

Originally Posted by samdba

The above command is supposed to be for RAC system

---

... who told you that?

Quote:

---

Originally Posted by samdba

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