17,377
社区成员
发帖
与我相关
我的任务
分享
declare
sql_str varchar2(4000);
begin
for c in (select * from logmnr_content) loop
sql_str := replace(c.sql_undo,';','');
execute immediate sql_str;
end loop;
commit;
end;
--scn和time_mp<scn对应的时间>的联系
SELECT * FROM sys.smon_scn_time ORDER BY time_mp DESC;
-- 取系统当前的scn
SELECT dbms_flashback.get_system_change_number c_SCN FROM dual;
--闪回查询
/*确认scn*/
SELECT COUNT(*) FROM your_table AS OF SCN &SCN;
--