Re: recycle bin not getting populated
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 10 Jun 2008 12:37:09 -0400
Message-Id: <484E7574.3406.000B.0@gcrta.org>
>>> "Bradd Piontek" <piontekdd_at_gmail.com> 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.
Date: Tue, 10 Jun 2008 12:37:09 -0400
Message-Id: <484E7574.3406.000B.0@gcrta.org>
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ recyclebin string onSQL>
>>> "Bradd Piontek" <piontekdd_at_gmail.com> 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_at_gcrta.org> 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. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 10 2008 - 11:37:09 CDT