UNDO
select dbms_flashback.get_system_change_number from dual;
update a set name='kerry' where id=1
select * from a as of scn 784613 where id=1
alter table a enable row movement
flashback table a to scn 784613
select versions_starttime, versions_endtime, versions_xid, versions_operation, c1
from flashback_test versions between timestamp minvalue and maxvalue
order by VERSIONS_STARTTIME ;
SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY WHERE XID = hextoraw('03002300C7040000') ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9907339/viewspace-1038119/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
