Home » SQL & PL/SQL » SQL & PL/SQL » Using recyclebin parameter
Using recyclebin parameter [message #260561] Mon, 20 August 2007 05:26 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10.1.0 release

I have set _recyclebin parameter to TRUE in init.ora file

SQL> show parameter _recyclebin

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
_recyclebin                          boolean     TRUE


create table a(n number);

Table created.

SQL> drop table a;

Table dropped.

SQL> show recyclebin
SQL> select count(*) from recyclebin;

  COUNT(*)
----------
         0




I am not able to see any objects in recyclebin after dropping them .
Should any other parameter be set along with recyclebin parameter ?
Re: Using recyclebin parameter [message #260575 is a reply to message #260561] Mon, 20 August 2007 06:15 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you restart the database after modifying the parameter?

Regards
Michel
Previous Topic: WHICH ONE IS FASTER?
Next Topic: Max statement
Goto Forum:
  


Current Time: Sat Aug 19 23:12:00 CDT 2017

Total time taken to generate the page: 0.19235 seconds