ORA-38305: object not in RECYCLE BIN
flashback dropped table doesnt't work in 11gr2 , why ?
Best regards.
GD.
SQL> create table toto as select * from user_objects ;Table createdSQL> select row_movement from user_tables where table_name ='TOTO' ;ROW_MOVEMENT------------DISABLEDSQL> alter table TOTO enable row movement ;Table alteredSQL> select row_movement from user_tables where table_name ='TOTO' ;ROW_MOVEMENT------------ENABLEDSQL> show parameter recyclebinNAME TYPE VALUE------------------------------------ ----------- ------------------------------recyclebin string onSQL> drop table toto ;Table droppedSQL> flashback table toto to before drop ;flashback table toto to before dropORA-38305: object not in RECYCLE BIN