oracle数据恢复小技巧

1、查询勿删的表 

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from RECYCLEBIN WHERE  original_name LIKE '%SYS_GL_TYPE%'

2、FLASHBACK语句进行恢复

FLASHBACK TABLE SYS_GL_TYPE TO BEFORE DROP RENAME TO SYS_GL_TYPE1; //假如数据库中有该表结构 需重命名 ，假如没有可不需要rename to

FLASHBACK TABLE SYS_GL_TYPE TO BEFORE DROP