Oracle数据库删库闪回

查询回收站

select * from user_recyclebin t 

恢复表与索引

上一步可以查出被删除的表，根据OBJECT_NAME 和 ORGINAL_NAME列对表闪回

-- flashback TABLE "OBJECT_NAME" to before drop rename to ORGINAL_NAME
flashback TABLE "BIN$7YCn5xhDo8bgVQAAAAAAAQ==$0" to before drop rename to TAB_name

重新修改索引名称

-- alter index "回收站中的名称" rename to 原始名称;
alter index "BIN$7aZrLrxRodTgVQAAAAAAAQ==$0" rename to IDX_XXX