ORA-38305: object not in RECYCLE BIN — oracle-mosc

Database Administration (MOSC)

MOSC Banner

ORA-38305: object not in RECYCLE BIN

edited Feb 22, 2013 3:31AM in Database Administration (MOSC) 5 commentsAnswered ✓
Hi ,

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

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