如何还原旧的plsql? [英] How to revert old plsql?

问题描述

昨天我更改了一个程序"MAIL_INSERT_CRON". 但是现在我希望我的旧程序恢复原状.. 是否可以检索我程序的旧内容?

yesterday i altered a procedure "MAIL_INSERT_CRON". but now i want my old procedure back.. It is possible to retrive old content of my procedure ?

推荐答案

如果满足以下条件，则可以从视图all_source中恢复代码:

You can recover the code from the view all_source if:

• 您有闪回功能，
• 您有权在数据字典视图(由SELECT_CATALOG_ROLE角色授予)上使用闪回，
• 数据仍位于闪回区域.

• you have flashback on,
• you have the privilege to use flashback on data dictionary views (which is granted by the SELECT_CATALOG_ROLE role),
• the data is still in the flashback area.

看来您没有闪回，或者数据已经被覆盖.在这种情况下，您将不得不退回到常规的丢失数据检索中:

It seems you don't have flashback on, or the data has been overwritten already. In that case you'll have to fallback to regular lost data retrieval:

• 您可以从删除之前恢复备份，
• 您可以使用 LogMiner 分析您的重做日志文件.

• you can restore a backup from before the drop,
• you can use LogMiner to analyze your redo log files.

这篇关于如何还原旧的plsql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！