Flashback

create table APPLSYS.FND_USER_TEMP as select * from applsys.FND_USER

as of timestamp(to_timestamp('06-02-2013:16:30:00', 'DD-MM-YYYY:HH24:MI:SS'))

When the table is dropped:

SQL> drop table APPLSYS.FND_USER_TEMP;

Table dropped.

SQL> select OWNER,OBJECT_NAME,ORIGINAL_NAME from dba_recyclebin where ORIGINAL_NAME='FND_USER_TEMP';

OWNER OBJECT_NAME

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

ORIGINAL_NAME

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

APPLSYS BIN$1Q+ETE9PKVjgRAAUT+g9XA==$0

FND_USER_TEMP

SQL> flashback table APPLSYS.FND_USER_TEMP to before drop;

Flashback complete.

SQL> select count(*) from APPLSYS.FND_USER_TEMP;

COUNT(*)

----------

4612

SQL> select count(*) from APPLSYS.FND_USER;

COUNT(*)

----------

4612