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