Logmnr的DDL

来源：互联网发布：手机如何网络翻墙编辑：程序博客网时间：2024/06/06 03:10

日志挖掘会挖到DDL

环境：11.2.0.4单机在Windows 2008R2

开始测试：

create table logmntest1 (id number);alter table logmntest1 add name varchar2(100);insert into logmntest1 values(1,'li');

然后挖掘出来的结果：--针对DDL

SQL_REDDO:insert into "SYS"."OBJ$"("OBJ#","DATAOBJ#","OWNER#","NAME","NAMESPACE","SUBNAME","TYPE#","CTIME","MTIME","STIME","STATUS","REMOTEOWNER","LINKNAME","FLAGS","OID$","SPARE1","SPARE2","SPARE3","SPARE4","SPARE5","SPARE6") values ('87243','87243','0','LOGMNTEST1','1',NULL,'2',TO_DATE('29-3月 -16', 'DD-MON-RR'),TO_DATE('29-3月 -16', 'DD-MON-RR'),TO_DATE('29-3月 -16', 'DD-MON-RR'),'1',NULL,NULL,'0',NULL,'6','1','0',NULL,NULL,NULL);

SQL_UNDO:delete from "SYS"."OBJ$" where "OBJ#" = '87243' and "DATAOBJ#" = '87243' and "OWNER#" = '0' and "NAME" = 'LOGMNTEST1' and "NAMESPACE" = '1' and "SUBNAME" IS NULL and "TYPE#" = '2' and "CTIME" = TO_DATE('29-3月 -16', 'DD-MON-RR') and "MTIME" = TO_DATE('29-3月 -16', 'DD-MON-RR') and "STIME" = TO_DATE('29-3月 -16', 'DD-MON-RR') and "STATUS" = '1' and "REMOTEOWNER" IS NULL and "LINKNAME" IS NULL and "FLAGS" = '0' and "OID$" IS NULL and "SPARE1" = '6' and "SPARE2" = '1' and "SPARE3" = '0' and "SPARE4" IS NULL and "SPARE5" IS NULL and "SPARE6" IS NULL and ROWID = 'AAAAASAABAAAVQkAAj';

这种直接操作数据库视图基表的行为，仅限看看，

0 0