Home » RDBMS Server » Backup & Recovery » How to disable the recyclebin in Oracle version 10.1?
How to disable the recyclebin in Oracle version 10.1? [message #202613] Fri, 10 November 2006 09:48 Go to next message
dreiger
Messages: 6
Registered: April 2005
Location: Broomfield, Co
Junior Member
For Oracle 10.2, Oracle documents how to disable the recyclebin:

SQL> ALTER SYSTEM SET recyclebin = OFF;

Howerver, in Oracle 10.1, the "recyclebin" parameter does not exist. Is there a different way to disable the recyclebin in version 10.1?

Thanks,
Derek
Re: How to disable the recyclebin in Oracle version 10.1? [message #202635 is a reply to message #202613] Fri, 10 November 2006 11:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try
"_recyclebin"=off
Re: How to disable the recyclebin in Oracle version 10.1? [message #202642 is a reply to message #202635] Fri, 10 November 2006 12:02 Go to previous messageGo to next message
dreiger
Messages: 6
Registered: April 2005
Location: Broomfield, Co
Junior Member
Thank you very much. The following command had the desired affect:

ALTER SYSTEM SET "_recyclebin"=FALSE SCOPE = BOTH;

A follow up question, if I may:

Is there a way to determine the current recyclebin configuration ... either enabled(true) or disabled(false)?

For Oracle 10.2, I can execute this:

select value from v$parameter where name = 'recyclebin';

But, for Oracle 10.1, the following query does not work:

select value from v$parameter where name = '_recyclebin';

Thanks,
Derek
Re: How to disable the recyclebin in Oracle version 10.1? [message #202649 is a reply to message #202642] Fri, 10 November 2006 12:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is the behaviour of hidden parameter.
You will not see it unless it is listed in init.ora exclusively.
As a workaround you need dig into the dictionary objects like
x$ksppinm and x$ksppstvl (and a few more? i am not sure).
Check metalink. There is supposed to be doc there.
icon10.gif  Re: How to disable the recyclebin in Oracle version 10.1? [message #205443 is a reply to message #202642] Fri, 24 November 2006 20:42 Go to previous messageGo to next message
tsololot
Messages: 1
Registered: November 2006
Location: malaybalay
Junior Member

i need your help
my recyclebin wsa lost and i dont know where is the recyclebin
the dekstop shortcut was delected

where can i find my recyclebin in my computer
Re: How to disable the recyclebin in Oracle version 10.1? [message #205498 is a reply to message #205443] Sat, 25 November 2006 05:06 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Huh, I'm afraid you mixed things up. True, Oracle and (I presume) MS Windows both use a term "Recycle Bin", but they are not the same. I believe you'd better ask this question on some MS Windows Forum, not Oracle FAQ Forum.
Re: How to disable the recyclebin in Oracle version 10.1? [message #209639 is a reply to message #202635] Sat, 16 December 2006 04:42 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Mahesh Rajendran wrote on Fri, 10 November 2006 11:37
try
"_recyclebin"=off



if we disable recycle_bin by using above mentioned command then will it change the behavior of table drop
if we drop table
SQL>drop table test_tb;
then i think table will dropped permanently and we can't perform
SQL>flashback table to before drop

its only my assumption what u'll suggest Sir?

thanx in advance

Re: How to disable the recyclebin in Oracle version 10.1? [message #209645 is a reply to message #209639] Sat, 16 December 2006 05:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Ofcourse yes.
And there ***could*** be many more related issues.
As we always advocate, any hidden parameters should be used after consulting OSS.

[Updated on: Sat, 16 December 2006 05:30]

Report message to a moderator

Re: How to disable the recyclebin in Oracle version 10.1? [message #209646 is a reply to message #209645] Sat, 16 December 2006 05:33 Go to previous message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Mahesh Rajendran wrote on Sat, 16 December 2006 05:26
Ofcourse yes.
And there ***could*** be many more related issues.
As we always advocate, any hidden parameters should be used after consulting OSS.




Thanx Mahesh for ur prompt response
Previous Topic: about 10g
Next Topic: how to take backup
Goto Forum:
  


Current Time: Tue Dec 06 11:56:33 CST 2016

Total time taken to generate the page: 0.10193 seconds