RE: recycle bin not getting populated

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 10 Jun 2008 13:28:43 -0400
Message-ID: <667C10D184B2674A82068E06A78382B51F7F1BE5@AAPQMAILBX01V.proque.st>


Nice catch! That never even dawned on me. I'm so used to LMTs these days, DMTs never even cross my mind.....

-Mark

--
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: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
Sent: Tuesday, June 10, 2008 1:14 PM
To: Bradd Piontek
Cc: oracle-l-freelists; oracle-db-l; Bobak, Mark
Subject: 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<mailto:JBECKSTROM_at_gcrta.org>> wrote: NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 10.2.0
>>> "Bobak, Mark" <Mark.Bobak_at_proquest.com<mailto: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> [mailto: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
Received on Tue Jun 10 2008 - 12:28:43 CDT

Original text of this message