Re: recycle bin not getting populated

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
recyclebin                           string      on
SQL>
 



>>> "Bradd Piontek" <piontekdd@xxxxxxxxx> 6/10/08 12:18 PM >>>
What is the value of  the 'recyclebin' parameter ??
If it isn't set to 'on', you won't have a recyclebin.

-- 
Bradd Piontek
Twitter: http://www.twitter.com/piontekdd 
Oracle Blog: http://piontekdd.blogspot.com (
http://piontekdd.blogspot.com/ )
Linked In: http://www.linkedin.com/in/piontekdd 
Last.fm: http://www.last.fm/user/piontekdd/ 

On Tue, Jun 10, 2008 at 11:00 AM, Jeffrey Beckstrom
<JBECKSTROM@xxxxxxxxx> wrote:


Upgraded a database to 10.2.0.4 ( http://10.2.0.4/ ) from 9.2.0.8 (
http://9.2.0.8/ ). Trying out some 10g features and notice recyclebin
is not working.

SQL>
SQL> create table jb (f1 number);

Table created.

SQL> drop table jb;

Table dropped.

SQL> select * from DBA_recyclebin;

no rows selected

SQL>

 

 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113






---------------------------------------------------------------------


Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.

Other related posts: