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;

一个包头
一个包体
原文地址:https://www.cnblogs.com/sprinng/p/5629304.html