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
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;


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

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

Current Time: Sat Jun 24 14:11:49 CDT 2017

Total time taken to generate the page: 0.07948 seconds