Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 28407 invoked from network); 10 Jun 2008 12:53:13 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 10 Jun 2008 12:53:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2502685DB16; Tue, 10 Jun 2008 13:53:08 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13745-04; Tue, 10 Jun 2008 13:53:08 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 85BFA85DA8A; Tue, 10 Jun 2008 13:53:07 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 10 Jun 2008 13:14:14 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0FCF585D571 for ; Tue, 10 Jun 2008 13:14:14 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08732-10 for ; Tue, 10 Jun 2008 13:14:13 -0400 (EDT) Received: from groupwise.gcrta.org (groupwise.gcrta.org [70.238.103.170]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8EE2385D0CB for ; Tue, 10 Jun 2008 13:14:12 -0400 (EDT) Received: from Main1-MTA by groupwise.gcrta.org with Novell_GroupWise; Tue, 10 Jun 2008 13:14:11 -0400 Message-Id: <484E7E1E.3406.000B.0@gcrta.org> Date: Tue, 10 Jun 2008 13:14:06 -0400 From: "Jeffrey Beckstrom" To: "Bradd Piontek" Cc: "oracle-l-freelists" , "oracle-db-l" , Subject: Re: recycle bin not getting populated References: <484E6CE4.3406.000B.0@gcrta.org> <667C10D184B2674A82068E06A78382B51F7F1B67@AAPQMAILBX01V.proque.st> <484E7596.3406.000B.0@gcrta.org> In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part96BF9D4E.0__=" X-archive-position: 8751 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-to: JBECKSTROM@gcrta.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --=__Part96BF9D4E.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit You nailed it - its dictionary managed >>> "Bradd Piontek" 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 wrote: NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 10.2.0 >>> "Bobak, Mark" 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@proquest.com ( mailto:mark.bobak@il.proquest.com ) www.proquest.com ( http://www.proquest.com/ ) www.csa.com ( http://www.csa.com/ ) ProQuest...Start here. From:oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@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. --=__Part96BF9D4E.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: 7bit You nailed it - its dictionary managed

>>> "Bradd Piontek" <piontekdd@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@gcrta.org> wrote:
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      10.2.0

>>> "Bobak, Mark" <Mark.Bobak@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@proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@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 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




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


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

--=__Part96BF9D4E.0__=-- -- http://www.freelists.org/webpage/oracle-l