recycle bin not getting populated

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 10 Jun 2008 12:00:37 -0400
Message-Id: <484E6CE4.3406.000B.0@gcrta.org>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 10 2008 - 11:00:37 CDT

Original text of this message