Oracle处理误drop表

一. Oracle处理误drop表

1. 查询user_recyclebin 表，看是否有误删除的表

select * from user_recyclebin a order by a.droptime desc;

2. 执行闪回操作

flashback table “BIN$7aW+MZWrWFTgU1YBrKy2lQ==$0” to before drop

3. 然后检查索引等操作。

select INDEX_NAME from user_indexes where TABLE_NAME=‘SYN_ROOMINFO_20221107’;

select constraint_name from user_constraints where TABLE_NAME=‘SYN_ROOMINFO_20221107’;
alter index “” rename to “”;