Accidental deletion of stored procedures, accidental deletion of file restoration Software
After the stored procedure is deleted by mistake, use the following statement to locate the deleted stored procedure and restore it. You need to log on with the sys user.
TIMESTAMP is the TIMESTAMP to be restored.
SELECT *
FROM DBA_SOURCE as of timestamp TO_TIMESTAMP ('2017-03-18 10:07:00 ', 'yyyy-MM-DD HH24: MI: ss ')
Where owner = 'user _ name'
And name = 'Procedure _ name'
Order by line;
DBA_SOURCE, ALL_SOURCE, and USER_SOURCE can all be found.
How to restore accidentally deleted system stored procedures
Recovery is impossible. Unless you have a backup in your database before deletion ..
For the error "Special updates to System directories are not enabled, the system administrator must reconfigure SQL Server to allow this operation", see hi.baidu.com/..5.html.
Q: How can I restore a stored procedure accidentally deleted by PL/SQL Developer?
Use Flashback to check whether the data can be recovered:
SELECT obj # FROM obj $ as of timestamp TO_TIMESTAMP (you time, 'yyyy-MM-DD HH24: MI: ss') where name = your procedure
SELECT * FROM source $ as of timestamp TO_TIMESTAMP (youtime, 'yyyy-MM-DD HH24: MI: ss') where obj #=? Id