如何只恢复经过多次commit后的某个事务
SQL> insert into t values(1);
1 row created.
SQL> commit;
Commit complete.
SQL> commit;
Commit complete.
SQL> delete from t where id = 1;
1 row deleted.
SQL> commit;
Commit complete.
用versions子句,而且用versions_starttime等虚列可以找到其中每个事务的开始时间(versions_starttime)和
操作(versions_operation虚列,D-delete I-insert,U-update等)
SQL> select versions_starttime,versions_xid,versions_operation from t
2 versions between timestamp minvalue and maxvalue;
VERSIONS_STARTTIME VERSIONS_XID V
----------------------------- ---------------- -
06-AUG-08 09.31.36 AM 17001C0079000000 D
06-AUG-08 09.31.27 AM 17001B0079000000 I
06-AUG-08 09.31.18 AM 17001A0079000000 I
然后从flashback_transaction_query表中根据相应的事务ID(versions_xid)可以找到相应的undo操作,
根据该操作可以直接rollback该事务!让人不得不佩服ORACLE的强大!
SQL> desc flashback_transaction_query;
Name Null? Type
----------------------------------------- -------- ----------------------------
XID RAW(8)
START_SCN NUMBER
....
UNDO_SQL VARCHAR2(4000)
SQL> select undo_sql from flashback_transaction_query where xid='17001A0079000000'
UNDO_SQL
--------------------------------------------------------------------------------
delete from "SYS"."T" where ROWID = 'AAAMSwAABAAANcaAAA';
SQL> select undo_sql from flashback_transaction_query where xid='17001C0079000000';
UNDO_SQL
--------------------------------------------------------------------------------
insert into "SYS"."T"("ID") values ('1');
发表评论
-
compile_6i
2010-10-12 21:35 535for %%i in (*.rdf) do start /w ... -
compile bat
2010-10-12 21:33 826compile_pll_form.bat for %%i i ... -
test26_7
2010-06-30 16:33 1315 使用索引:索引未用上?是否为表和相关的索引搜集足够的统计 ... -
test26_6
2010-06-30 16:32 1414 使用索引:索引未用上?检查被索引的列或组合索引的首列是否 ... -
test26_5
2010-06-30 16:31 64413 使用索引:合理的索引针对如何用上合理的索引,以下举ORA ... -
test26_4
2010-06-30 16:30 59211 使用索引:建立索引的原则1、索引字段需要建立NOT NU ... -
test26_3
2010-06-30 16:29 5419 索引种类:位图索引Create BITMAP index ... -
test26_2
2010-06-30 16:28 5147 索引种类:反向索引Create index indexna ... -
test26_1
2010-06-30 16:26 6634 索引概述:什么是索引索引是建立在表的一列或多个列上的辅助对 ... -
test26_0
2010-06-30 16:25 5421 Oracle 索引 2 Contents索引概述什么是索 ... -
test25
2010-06-30 15:59 541如何收集表的部分统计信息 如果表很大,收集表的统计信息需要花 ... -
test24
2010-06-30 15:53 565处理exp Exporting questionable st ... -
test23_1
2010-06-30 15:49 623Argument Name ... -
test23
2010-06-30 15:47 532回收表的高水平位 表的高水平位(High water mar ... -
test22
2010-06-30 15:29 572dblink的使用1、现象、问题描述 在local服务器上有 ... -
test21
2010-06-30 15:29 589如何查询长时间的操作何时结束 数据库中有一个视图中v$ses ... -
test19_1
2010-06-28 16:45 499但ORACLE又提供了另外一种机制:从redo日志或归档日志中 ... -
test19_1
2010-06-28 16:43 439但ORACLE又提供了另外一种机制:从redo日志或归档日志中 ... -
test19
2010-06-28 16:43 666如何恢复删除并且commit ... -
test18
2010-06-28 16:39 483如何使一个经常用的小表一直保留在内存中? SQL> s ...
相关推荐
Test20-WebSocket.zip
Nokia Monitor Test v20 专业的 LCD 显示器 检测软件
所有购买 killtest 认证考题的客户都将得到60天的免费升级服务,保证了对Networked Storage-CAS Installat''''n/Troubleshooting Specialst考试题库的完整覆盖。 killtest 助你一次通过 Networked Storage-CAS ...
PassMark BurnInTest V5.3 Copyright (C) 1999-2008 PassMark Software All Rights Reserved http://www.passmark.com Overview ======== Passmark's BurnInTest is a software tool that allows all the major sub...
JEP176:2018 ADAPTER TEST BOARD RELIABILITY TEST GUIDELINES - 完整英文电子版(20页) .zip
JspTest是一个不依赖予容器,对jsp页面进行单元测试的junit扩展。内部它使用Jasper作为jsp编译引擎---tomcat的jsp引擎。... <artifactId>jsptest-jsp20 <version>0.21 标签:JspTest
Test-driven development (TDD) is a development approach that relies on a test-first procedure that emphasises writing a test before writing the necessary code, and then refactoring the code to ...
18800 SRVCC Test Cases V20.xlsx
testcomplete720 XX的东东 也上传在我的资源里面啦
创建vlan 20 Switch(config-vlan)#name test20 !vlan 20命名为test20 Switch#show vlan !查看已配置的vlan信息 实验代码和实验结果如下图(6)所示: 实验二-交换实验-VLAN及链路冗余实验报告全文共19页
app-test_test-v2.0-20_11111.apk.1
测试用0db正弦波音频源文件集合打包 . ├── 00....├── Slow_freq_sweep_61_-20dB_44k.16.wav ├── Subwoofer-delay-test.wav └── 左右声道及喇叭极性Sound Check_Channel & Phase_10sec.wav
Killtest提供最新的 000-M20 资料下载
18B20温度控制器,测试通过,18B20 Temperature controller, the test pass
test 2048c语音 /* WIN-TC BGI 图形编程模板 */ #include "Conio.h" #include "graphics.h" #include "time.h" #include "stdlib.h" #define VK_LEFT 0x4b00 #define VK_RIGHT 0x4d00 #define VK_DOWN 0x5000 #...
<mx:Spacer width="20"/> [A-Z,0-9]" validator="{fltNoValidator}"/> [A-Z,0-9]" text="{this.formatDate(new Date)}" validator="{fltDateValidator}" /> ...
final20~21_test426.html
20 SQLite的体系结构简介 ................................................................ 21 简介 ............................................................................. 21 接口程序 ...............