oracle 的PACKAGE恢复过程 

SELECT obj# FROM obj$ AS OF TIMESTAMP TO_TIMESTAMP('2016-06-30', 'YYYY-MM-DD') WHERE NAME = 'PFWZ_APPLICATION_OPERATION';
87842
87852

SELECT source FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2016-06-30', 'YYYY-MM-DD') where obj# = 87842;
SELECT source FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2016-06-30', 'YYYY-MM-DD') where obj# = 87852;

一个包头
一个包体

 

posted @ 2016-06-30 11:02  Earic  阅读(1031)  评论(0)  编辑  收藏  举报