Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Can't I mine DDL statements from LogMiner?

Can't I mine DDL statements from LogMiner?

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Tue, 13 Dec 2005 14:54:17 -0800
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B9010EB2CD@wafedixm10.corp.weyer.pri>


 Oracle version is 9206.

I'm tracking DDL changes by running such a query:

select object_name,to_char(last_ddl_time,'YYYY-MM-DD-HH24:MI:SS'), timestamp from dba_objects
where last_ddl_time > sysdate-4;

Produces some output like the following:

OBJECT_NAME TO_CHAR(LAST_DDL_TI TIMESTAMP
-------------------- ------------------- -------------------

OBJ1                 2005-12-11-03:01:16 2001-02-01:01:07:39
OBJ2                2005-12-11-03:01:16 2001-01-29:20:38:59

I then fire up logminer and load all the logs (3 of them) from before and after 3:01.

I then run this query.

select sql_redo,to_char(timestamp, 'YYYY-MM-DD-HH24:MI:SS'), operation, sql_undo
from v$logmnr_contents where seg_name like '%OBJ1%';

Produces no output for DDL (there is some for DML though).

I then try this, which produces no output as well.

select sql_redo,to_char(timestamp, 'YYYY-MM-DD-HH24:MI:SS'), operation, sql_undo
from v$logmnr_contents where operation = 'DDL'

Am I missing something? I thought Logminer in 9i could report DDL changes?

The other question is, is someone already tracking something similar to this (DDL changes) -- how are you accomplishing this?

Thanks much!!

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 13 2005 - 16:54:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US