logminer来恢复在表DDL之前被删除的数据(5)

USERNAME                              SCN TIMESTAMP  SQL_REDO                                                                                                              SQL_UNDO
------------------------------ ---------- ---------  -------------------------------------------------------------------------------------------------------------------  ------------------------------------------------------------------------------------------------------------------------
UNKNOWN                          1102088 13-MAY-16  create table t1(t_id number,t_name varchar2(50));

JY                                1102114 13-MAY-16  alter table t1 add t_salary number(8);

UNKNOWN                          1102129 13-MAY-16  insert into "JY"."T1"("T_ID","T_NAME","T_SALARY") values ('1','jy','10000');                                          delete from "JY"."T1" where "T_ID" = '1' and "T_NAME" = 'jy' and "T_SALARY" = '10000' and ROWID = 'AAANc6AAEAAAAGEAAA';

UNKNOWN                          1102822 13-MAY-16  insert into "JY"."T1"("T_ID","T_NAME","T_SALARY") values ('2','wj','8000');                                            delete from "JY"."T1" where "T_ID" = '2' and "T_NAME" = 'wj' and "T_SALARY" = '8000' and ROWID = 'AAANc6AAEAAAAGFAAA';

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/a171bb74c81aa36378b175944a5b2d4d.html