Oracle syntax
User trashcan
List trashcan items:
SELECT OBJECT_NAME, ORIGINAL_NAME, TYPE FROM USER_RECYCLEBIN;
Restore table from trashcan:
FLASHBACK TABLE A TO BEFORE DROP;
Flashback complete
Clear trashcan:
PURGE USER_RECYCLEBIN;
Create synonym
CREATE SYNONYM <SYNONYM_NAME> FOR <SCHEMA>.<TABLE>;
Read other posts