对表进行了3个插入,然后一起commit
insert into yan_test values('11');
insert into yan_test values('22');
insert into yan_test values('33');
commit;然后我认为这个事务是错误的,希望flashback,取消这个事务
select versions_startscn,versions_endscn,versions_starttime,versions_endtime, versions_xid,versions_operation,ftelno from yan_test versions between timestamp minvalue and maxvalue
得到的结果是:
3条记录,3条记录的xid均是000C000300161D38
通过这个xid去找undo_sql
select undo_sql from FLASHBACK_TRANSACTION_QUERY where xid=HEXTORAW('000C000300161D38')
得到的结果是:
delete from "YAN_TEST" where ROWID = 'AAAX+oAAGAAGaqFAAB';但是这条语句只是删除值为“11”的那条记录,也就是事务开始的第一条记录,另外2条记录的如何flashback?
insert into yan_test values('11');
insert into yan_test values('22');
insert into yan_test values('33');
commit;然后我认为这个事务是错误的,希望flashback,取消这个事务
select versions_startscn,versions_endscn,versions_starttime,versions_endtime, versions_xid,versions_operation,ftelno from yan_test versions between timestamp minvalue and maxvalue
得到的结果是:
3条记录,3条记录的xid均是000C000300161D38
通过这个xid去找undo_sql
select undo_sql from FLASHBACK_TRANSACTION_QUERY where xid=HEXTORAW('000C000300161D38')
得到的结果是:
delete from "YAN_TEST" where ROWID = 'AAAX+oAAGAAGaqFAAB';但是这条语句只是删除值为“11”的那条记录,也就是事务开始的第一条记录,另外2条记录的如何flashback?
解决方案 »
- 还是grid control问题
- ORACLE 10G OEM里可以shutdown或start实例吗?
- 问一个弱问题,oracle能作为邮件服务器使用吗?
- alter table tb_name move tablespace tbs_name ???
- 请问sys.v$session视图是由什么表创建而来的?
- 献分讨论:google是如何用内存数据库作为缓存的 google后台用什么分布数据库
- SQL PLUS 建表的问题,自己做了很久了,只能求助大家了-----
- 本人太菜了实在搞不明白,这条SQL语句怎么会产生这样的结果?
- 插入大字段的问题,一百分相送!!!!在线等待。
- 请问Oracle安装有多少东东要装
- 新年问个动态SQL问题
- 异常号是ora-01476,我怎么查找帮助文档才能知道他的异常类型名呢
SQL> create table yan_test (f1 varchar2(20));Table created.SQL> insert into yan_test values('11');1 row created.SQL> c/11/22
1* insert into yan_test values('22')
SQL> /1 row created.SQL> c/22/33
1* insert into yan_test values('33')
SQL> /1 row created.SQL> commit;SQL> select versions_startscn, versions_endscn, versions_starttime, versions_endtime, versions_xid,
2 versions_operation, f1 from yan_test versions between timestamp minvalue and maxvalue;VERSIONS_STARTSCN VERSIONS_ENDSCN VERSIONS_STARTTIME
----------------- --------------- ---------------------------------------------------------------------------
VERSIONS_ENDTIME VERSIONS_XID V F1
--------------------------------------------------------------------------- ---------------- - --------------------
15932185 11-FEB-10 12.31.52 PM
090008009A1D0000 I 33 15932185 11-FEB-10 12.31.52 PM
090008009A1D0000 I 22 15932185 11-FEB-10 12.31.52 PM
090008009A1D0000 I 11
SQL> select undo_sql from flashback_transaction_query where xid = hextoraw('090008009A1D0000');UNDO_SQL
-------------------------------------------------------------------------------------------------------------------
delete from "HR"."YAN_TEST" where ROWID = 'AAAURIAAEAAB4wGAAC';
delete from "HR"."YAN_TEST" where ROWID = 'AAAURIAAEAAB4wGAAB';
delete from "HR"."YAN_TEST" where ROWID = 'AAAURIAAEAAB4wGAAA';我做了實驗,得出有3條undo_sql記錄。
SQL> select f1, rowid from yan_test;F1 ROWID
-------------------- ------------------
11 AAAURIAAEAAB4wGAAA
22 AAAURIAAEAAB4wGAAB
33 AAAURIAAEAAB4wGAAC