Re: recycle bin not getting populated

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


Other related posts: