Re: recycle bin not getting populated
From: Kurt Franke <Kurt-Franke_at_web.de>
Date: Tue, 10 Jun 2008 18:54:42 +0200
Message-Id: <1002030969@web.de>
Date: Tue, 10 Jun 2008 18:54:42 +0200
Message-Id: <1002030969@web.de>
Jeffrey,
may be you had created the table on a dictionary managed tablespace ?
For those dictionary managed tablespaces the recyclebin mechanism is not supported whether or not it is enabled for the database
Nevertheless this may be considered a feature because disabling recycle bin is not possible for tablespaces or schemas but only for the complete database or for specific sessions.
regards
kf
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 10 2008 - 11:54:42 CDT