如果不小心删除掉了使用的存储过程，是一件非常的令人担心和可怕的事情，但如果及时发现还是可以挽回的。

--使用闪回查询删除的对象和ID

Select a.Obj#, b.Object_Name, b.Object_Type, b.Owner  From (Select Obj#, Name, Type#, Owner#      From Obj$ As Of Timestamp To_Timestamp('2011-12-13 17:00:00', 'YYYY-MM-DD HH24:MI:SS')      Where Name = Upper('pk_query_policy')) a,     Dba_Objects b  Where a.Obj# = b.Object_Id   And b.Owner = 'NTICKET'

--通过对象ID再查找代码

SELECT * FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2011-12-13 17:00:00', 'YYYY-MM-DD HH24:MI:SS') where obj#=172442 order by line