Recyclebin is empty
I have flashback on the database.
verified the recyclebin is on
created and dropped a table but I am not find the table in user_recylebin or show recylcebin.
SQL> create table sys.A(no number);
Table created.
SQL> drop table sys.A;
Table dropped.
SQL> show recyclebin;
SQL> select original_name from dba_recyclebin;
ORIGINAL_NAME
--------------------------------
PK_MGMT_IP_NLS_MAP
MGMT_IP_REPORT_NLS_MAP
T1
COE_SCHEMAS
COE_TABLES
Please help why I am not able to see the drop table in recyclebin ?
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
SQL> SELECT Value FROM V$parameter WHERE Name = 'recyclebin';
VALUE
---------------------------------------------------------------
on
Edited by: user12178861 on Apr 25, 2011 12:21 PM