Re: recycle bin not getting populated
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Tue, 10 Jun 2008 11:49:17 -0500
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>
wrote:
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> compatible string 10.2.0
>
> >>> "Bobak, Mark" <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 <mark.bobak@xxxxxxxxxxxxxxx>
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* 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 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/
Other related posts:
