Oracle Database Discussions

Could you anyone give any kind of solution as to why the recycle bin is not working properly .

Below is the SQL

Oracle 10g VERSION  - Oracle version

Linux RedHat   - Operating System

Flashback is On

Archivelog Mode

SQL> SHOW PARAMETER RECYCLEBIN;

NAME                                 TYPE        VALUE

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

recyclebin                           string            ON

SQL> CREATE TABLE T1(AGE NUMBER);

Table created.

SQL> DROP TABLE T1;

        Table dropped.

SQL> FLASHBACK TABLE T1 TO BEFORE DROP;

FLASHBACK TABLE T1 TO BEFORE DROP

*ERROR at line 1:

ORA-38305: object not in RECYCLE BIN

SQL> SHOW RECYCLEBIN;    WHEN I EXECUTED THIS STATEMENT NOTHING IS HAPPENING  IT JUST PASSES TO NEXT SQL PROMPT

SQL> SELECT * FROM USER_RECYCLEBIN;

    no rows selected

SQL> SELECT * FROM DBA_RECYCLEBIN;

no rows selected

Thanks

Any kind of information is highly appreciable