SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL>
SQL> sho user
USER is "SYS"
SQL> create table syst_michel(d2 number) tablespace users;

Table created.

SQL> drop table syst_michel;

Table dropped.

SQL> flashback table syst_michel to before drop;

Flashback complete.

SQL> desc syst_michel
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 D2                                                 NUMBER

SQL> select owner,object_name
  2  from dba_objects
  3  where object_name='SYST_MICHEL';

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SYS
SYST_MICHEL




SQL> create table dawn (d1 number);

Table created.

SQL> sho user
USER is "SYS"
SQL> desc dawn
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 D1                                                 NUMBER

SQL> drop table dawn;

Table dropped.

SQL> flashback table dawn to before drop;
flashback table dawn to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN


SQL>