(52-30)第49次上完1Z0-053第10章，2016-02-25星期四

admin · 发表于 2016-2-26 16:43:30

http://124.16.180.178:8080/studentguide_sec_O11g/

游客，本帖隐藏的内容需要积分高于 100 才可浏览，您当前积分为 0

select *
from flashback_transaction_query q
where q.logon_user = 'HR'
and q.table_name = 'TAB
;
---
alter database add supplemental log data;
---
select * from tab$ where rowid = 'AAAAACAABAAAPh9AAA';
select * from dba_objects o where o.object_id = '80573';
---
select t.row_movement
from dba_tables t
where t.owner = 'HR'
and t.table_name = 'EMPLOYEES';
---
select d.SUPPLEMENTAL_LOG_DATA_MIN,
d.SUPPLEMENTAL_LOG_DATA_PK,
d.SUPPLEMENTAL_LOG_DATA_UI,
d.SUPPLEMENTAL_LOG_DATA_FK,
d.SUPPLEMENTAL_LOG_DATA_ALL
from v_$database d;
alter database add supplemental log data(primary key) columns;
----
select * from hr.regions;
select versions_xid,
versions_operation,
versions_startscn,
region_id,
region_name
from hr.regions versions between scn minvalue and maxvalue
order by versions_startscn;
begin
dbms_flashback.transaction_backout(numtxns => 1,
xids => sys.xid_array('03001F00B8050000'),
options => dbms_flashback.nocascade_force);
end;
rollback;
select * from dba_flashback_txn_report;
select * from dba_flashback_txn_state;
select * from hr.regions;
-------
select versions_xid,
versions_operation,
versions_startscn,
id
from hr.tnocascade_force versions between scn minvalue and maxvalue
order by versions_startscn;
---
select *
from flashback_transaction_query q
where q.logon_user = 'HR'
and q.table_name = 'NONCONFLICT_ONLY' order by commit_scn ;
select * from dba_flashback_txn_report;
--050020006D060000
begin
dbms_flashback.transaction_backout(numtxns => 1,
xids => sys.xid_array('0700090031050000'),
options => dbms_flashback.nonconflict_only);
end;

复制代码