查询出被删除表名
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin order by DROPTIME desc;
BIN$v7NJ2kOSQK69uG77XshGYw==$0 T_CHRYSLER_PARTS_BAK TABLE FTCARXE4 2019-03-12:06:44:33 2019-03-13:17:28:13
BIN$28RU97teT36cv6r8Xb1DOA==$0 T_CHRYSLER_PARTS_SYSNO INDEX FTCARXE4 2018-11-11:10:12:34 2019-03-13:16:29:46
BIN$dVrxWivNRt6HqDsCkGKQPw==$0 T_CHRYSLER_PARTS_RID_INX1 INDEX FTCARXE4 2019-03-13:12:19:10 2019-03-13:16:29:46
恢复表
flashback table "BIN$WdUwC9UWSSePpPsUQiIcZg==$0" to before drop;