Steps to Recover dropped table from Recycle-Bin in Oracle

Scenario :

SQL> select count(*) from APPS.FND_EXECUTABLES;

select count(*) from APPS.FND_EXECUTABLES

                                 *

ERROR at line 1:

ORA-00980: synonym translation is no longer valid

Solution :

Whenever the object is dropped the object will be moved to recyclebin.

In our case we accidentally dropped fnd_executable .

Below steps shows how we recovered the dropped table

1. drop table applsys.fnd_executable;

     Table dropped

 When a table and its dependent objects are moved to the recycle bin, they are assigned unique names, to avoid name conflicts that may arise in the following circumstances:

• A user drops a table, creates another with the same name, then drops the second table.
• Two users have tables with the same name, and both users drop their tables.

e.g : BIN$$globalUID$version

• globalUID is a globally unique, 24 character long identifier generated for the object.
• version is a version number assigned by the database

2. 

SQL> show recyclebin;

ORIGINAL NAME                  RECYCLEBIN NAME                         TYPE         DROP TIME

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

FND_EXECUTABLES    BIN$OJ50JJ9cGO/gU6EBqMDpjw==$0   TABLE   2016-07-27:18:43:25

The database also provides two views for obtaining information about objects in the recycle bin:

USER_RECYCLEBIN               - Lets users see their own dropped objects in the recycle bin. It has                                                            a synonym RECYCLEBIN, for ease of use.

DBA_RECYCLEBIN                  - Lets administrators see all dropped objects in the recycle bin.

3. Find whether the object can be recovered or not checking can_undrop value if it is yes we can

SQL > select owner, object_name, original_name, operation, type, can_undrop, can_purge, droptime from dba_recyclebin where original_name='FND_EXECUTABLES';

4. Performing Flash back to recover table

SQL> flashback table applsys.FND_EXECUTABLES to before drop;

Flashback complete.

5.  Check now

SQL > select count(*) from APPS.FND_EXECUTABLES;

  COUNT(*)

----------

      9400

Table Recovered Successfully

For more Info https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm