RE: recycle bin not getting populated
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>, Bradd Piontek <piontekdd@xxxxxxxxx>
- Date: Tue, 10 Jun 2008 13:28:43 -0400
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@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
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@xxxxxxxxx> 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@xxxxxxxxx<mailto:JBECKSTROM@xxxxxxxxx>> wrote:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0
>>> "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>>
>>> 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@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com/>
www.csa.com<http://www.csa.com/>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] 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.
Other related posts:
