LogmnrのDDL
2054 ワード
ログマイニングでDDLが掘られます
環境:11.2.0.4単機Windows 2008 R 2
テストの開始:
そして掘り起こした結果:DDLに対して
このようなデータベース・ビューのベース・テーブルを直接操作する動作は、見ているだけで、
環境:11.2.0.4単機Windows 2008 R 2
テストの開始:
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';
このようなデータベース・ビューのベース・テーブルを直接操作する動作は、見ているだけで、