2 Replies Latest reply on Jan 19, 2016 5:00 PM by rp0428

    Oracle 11g: Tables are not stored in recyclebin


      Dear Team,


      I'm a newbie to Oracle Database. I'm facing a problem that my dropped objects are not available in recyclebin even though it is enabled.

      Kindly help me to fix it.


      SQL> show user

      USER is "SYS"

      SQL> show parameter recyclebin

      NAME                                 TYPE        VALUE

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

      recyclebin                           string      ON

      SQL> drop table tab1;

      Table dropped.

      SQL> show recyclebin;

      SQL> select * from user_recyclebin;

      no rows selected