How to determine whether a table is used to store materialized view logs?

turbanoff picture turbanoff · Jan 22, 2013 · Viewed 15.2k times · Source

I have table with created on it materialized view log:

create table T1(A number primary key);
create materialized view log on T1 with primary key;

Oracle additionally creates two tables for materialized view logs:

select TABLE_NAME from USER_TABLES

|T1       |
|MLOG$_T1 |
|RUPD$_T1 |

How to determine that RUPD$_T1 table is a table with the mview logs for T1?

I can determine this for MLOG$_T1:

select MASTER, LOG_TABLE from USER_MVIEW_LOGS

|T1       |MLOG$_T1 |

But where to find a reference to the table RUPD$_T1?

Answer

DazzaL picture DazzaL · Jan 22, 2013

its in the SYS base table. i.e.

SQL> select  master, log, temp_log from sys.mlog$ where mowner = user and master = 'T1';

MASTER               LOG                  TEMP_LOG
-------------------- -------------------- --------------------
T1                   MLOG$_T1             RUPD$_T1