Rebuild materialized view log

Question

I need to drop and re-create a view log only if it references a specific column. I don't see anything in dba_mview_logs or sys.mlog$ that describes the base columns a view log references.

Answer 1

Try this one:

SELECT MASTER, LOG_TABLE, COLUMN_NAME 
FROM USER_MVIEW_LOGS
    JOIN USER_TAB_COLS c ON table_name = LOG_TABLE
WHERE MASTER = 'TABLE_WHERE_LOGS_ARE_TAKEN'