回收站

启用回收站

alter system set recyclebin=on scope=both;

查询回收站信息

dba_recyclebin

还原表的最新版本

flashbacktable confirm_tabletobeforedrop

重命名主键约束与INDEX约束

alter index "BIN$u9gKTHIDTbq0kZvyC92a+g==$0" rename to index_test;

alter table confirm_table rename constraint "BIN$gwv7RHO3TRS3XCtfUvHrbg==$0" to pk_test;