Recyclebin

[ndisang]

double check!! It works

Check list:
> DB_FLASHBACK_RETENTION_TARGET set
> FLASHBACK database ON
> check SELECT FLASHBACK_ON FROM V$DATABASE; --Yes
> RECYCLEBIN ON
> create table, drop and flash back --should work

Thanks
I see the issue is with the flsah back not coming on....

SQL> sho parameter retention

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target integer 1440

SQL> ALTER SYSTEM SET RECYCLEBIN = 'ON';

System altered.

SQL> SELECT FLASHBACK_ON FROM V$DATABASE;

FLASHBACK_ON
------------------
NO <-----you would expect this value to be YES but why no?