Database Administration (MOSC)

MOSC Banner

11gr2 : Dropped table not exists in enabled recyclebin

edited Mar 5, 2015 10:05AM in Database Administration (MOSC) 5 commentsAnswered

Hi  ,

Why it's not possible to  find a table dropped with this command :

EXECUTE IMMEDIATE "DROP TABLE EMP1" ;   -- PURGE option is not used !

SQL> SELECT name , value FROM V$parameter WHERE upper(NAME) like '%RECYCLEBIN%';

NAME                                          VALUE

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

recyclebin                                    on        -- recyclebin is enabled !

select  *  from  dba_RECYCLEBIN rb where upper(rb.object_name) like '%EMP%' or upper(rb.original_name) like '%EMP%' ;

-- no rows

How to restore this table asap ?

Best regards.

GD.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center