【oracle】dbms_flashback

【oracle】dbms_flashback

1028-04 dbms_flashback
--查看执行过的sql:select,insert,update,delete
select * from v$sql
where service ='ionmc' and parsing_schema_name = 'SCOTT';

--查看 执行过的sql: insert,update,delete
grant select any transaction to scott;
select * from flashback_transaction_query where logon_user = 'SCOTT';

posted on 2018-04-05 11:56  绿Z 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/greenZ/p/8721807.html