OraFAQ Forum: Backup & Recovery » How to disable the recyclebin in Oracle version 10.1?

Home » RDBMS Server » Backup & Recovery » How to disable the recyclebin in Oracle version 10.1?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to disable the recyclebin in Oracle version 10.1? [message #202613]

Fri, 10 November 2006 09:48

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try

"_recyclebin"=off

Report message to a moderator

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

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

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

Report message to a moderator

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

Littlefoot
Messages: 21808
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.

Report message to a moderator

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

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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

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

Report message to a moderator

Previous Topic:	about 10g
Next Topic:	how to take backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 01:56:21 CDT 2024