Re: recycle bin not getting populated

You nailed it - its dictionary managed

>>> "Bradd Piontek" <piontekdd_at_gmail.com> 6/10/08 12:49 PM >>>
One more thing to check. Check the extent management of the tablespace the table is in.

recyclebin only works on locally managed tablespaces:

select extent_management from dba_tablespaces where tablespace_name = 'WHATEVERYOUUSED"; On Tue, Jun 10, 2008 at 11:37 AM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
compatible                           string      10.2.0

>>> "Bobak, Mark" <Mark.Bobak_at_proquest.com> 6/10/08 12:19 PM >>>

Show parameter compatible    

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak_at_proquest.com ( mailto:mark.bobak_at_il.proquest.com )
www.proquest.com ( http://www.proquest.com/ )
www.csa.com ( http://www.csa.com/ )

ProQuest...Start here.

 

From:oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey
Beckstrom
Sent: Tuesday, June 10, 2008 12:01 PM
To: oracle-l-freelists; oracle-db-l
Subject: recycle bin not getting populated

 

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.





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



---------------------------------------------------------------------


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