如果不小心删除掉了使用的存储过程,是一件非常的令人担心和可怕的事情,但如果及时发现还是可以挽回的。
--使用闪回查询删除的对象和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