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