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>;