-- find object_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('2012-05-15 23:35:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE Name = Upper('show_space_kin')
) a,
Dba_Objects b
WHERE A.OBJ# = B.OBJECT_ID
AND B.OWNER = 'SCOTT';
-- flashback the procedure source code
SELECT source
FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2012-05-15 23:37:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE obj#=73876
ORDER BY line;
Oracle-flashback query drop procedure
最新推荐文章于 2024-06-03 21:21:38 发布