10g可以使用flashback功能恢复,10g以下使用logminerSELECT obj# FROM obj$ AS OF TIMESTAMP TO_TIMESTAMP('删除之前的时间', 'YYYY-MM-DD HH24:MI:SS') WHERE NAME = '存储过程名';SELECT * FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('删除之前的时间', 'YYYY-MM-DD HH24:MI:SS') WHERE obj# = 172442; ORDER BY line;
grant select any dictionary to user_name;
用system登陆可以了,但查不到obj# 的值啊
SELECT obj# FROM obj$ as of timestamp sysdate -24/60/360 WHERE NAME = 'SP_NAME; 这样就可以恢复了。
FROM obj$ AS OF TIMESTAMP TO_TIMESTAMP('删除之前的时间', 'YYYY-MM-DD HH24:MI:SS')
WHERE NAME = '存储过程名';SELECT *
FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('删除之前的时间', 'YYYY-MM-DD HH24:MI:SS')
WHERE obj# = 172442;
ORDER BY line;
grant select any dictionary to user_name;
FROM obj$ as of timestamp sysdate -24/60/360 WHERE NAME = 'SP_NAME;
这样就可以恢复了。
10g可以使用flashback功能恢复怎么做??