Grokbase › Groups › Oracle › oracle-l › June 2008
FAQ
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

Search Discussions

  • Bradd Piontek at Jun 10, 2008 at 4:18 pm ⇧
    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
    wrote:
    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
  • Jeffrey Beckstrom at Jun 10, 2008 at 4:37 pm ⇧
    NAME TYPE VALUE
    ------------------------------------ -----------
    ------------------------------
    recyclebin string on

    SQL>


    "Bradd Piontek" 6/10/08 12:18 PM >>>
    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 (
    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
    wrote:

    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.

    --
    http://www.freelists.org/webpage/oracle-l
  • Bobak, Mark at Jun 10, 2008 at 4: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
    www.proquest.com<http://www.proquest.com>
    www.csa.com<http://www.csa.com>

    ProQuest...Start here.

    From: 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 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
  • Jeffrey Beckstrom at Jun 10, 2008 at 4:37 pm ⇧
    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_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
    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.

    --
    http://www.freelists.org/webpage/oracle-l
  • Bradd Piontek at Jun 10, 2008 at 4: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_at_proquest.com
    www.proquest.com
    www.csa.com

    *ProQuest...*Start here.



    *From:* oracle-l-bounce_at_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/

    --
    http://www.freelists.org/webpage/oracle-l
  • Jeffrey Beckstrom at Jun 10, 2008 at 5:14 pm ⇧
    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_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
    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
  • Bobak, Mark at Jun 10, 2008 at 5:28 pm ⇧
    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
    www.proquest.com<http://www.proquest.com>
    www.csa.com<http://www.csa.com>

    ProQuest...Start here.

    From: Jeffrey Beckstrom
    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" 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_at_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] 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
  • Kurt Franke at Jun 10, 2008 at 4:54 pm ⇧
    Jeffrey,

    may be you had created the table on a dictionary managed tablespace ?

    For those dictionary managed tablespaces the recyclebin mechanism is not
    supported whether or not it is enabled for the database

    Nevertheless this may be considered a feature because disabling recycle bin
    is not possible for tablespaces or schemas but only for the complete database or
    for specific sessions.

    regards

    kf
    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
    --
    http://www.freelists.org/webpage/oracle-l
  • Dba1 mcc at Jun 10, 2008 at 5:31 pm ⇧
    select * from user_recyclebin;


    Jeffrey Beckstrom wrote:

    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 10, '08 at 4:00p
activeJun 10, '08 at 5:31p
posts10
users5
websiteoracle.com

5 users in discussion

Jeffrey Beckstrom: 4 posts Bobak, Mark: 2 posts Bradd Piontek: 2 posts Dba1 mcc: 1 post Kurt Franke: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase