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

15,651

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
Share:
15,651
turbanoff
Author by

turbanoff

Developer (Java, C#, Oracle)

Updated on June 05, 2022

Comments

  • turbanoff
    turbanoff about 2 years

    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?