Re: recycle bin not getting populated
From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Tue, 10 Jun 2008 11:18:25 -0500
Message-ID: <e9569ef30806100918w745d04e8g74fb446286fdd8c2@mail.gmail.com>
Date: Tue, 10 Jun 2008 11:18:25 -0500
Message-ID: <e9569ef30806100918w745d04e8g74fb446286fdd8c2@mail.gmail.com>
What is the value of the 'recyclebin' parameter ??
If it isn't set to 'on', you won't have a recyclebin.
-- 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/ On Tue, Jun 10, 2008 at 11:00 AM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:Received on Tue Jun 10 2008 - 11:18:25 CDT
> 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
>
-- http://www.freelists.org/webpage/oracle-l