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: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you restart the database after modifying the parameter?

Regards
Michel
Previous Topic: max select on specific date format
Next Topic: Error when using Collections / Records
Goto Forum:
  


Current Time: Mon Dec 05 05:12:00 CST 2016

Total time taken to generate the page: 0.04773 seconds