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

:

SQL>conn manjit/manjit;
Connected.
SQL> create table T1(A number primary key);

Table created.

SQL> create materialized view log on T1 with primary key;

Materialized view log created.

SQL> select TABLE_NAME from USER_TABLES;

TABLE_NAME
------------------------------
MANJU
MANJIT
SYS_EXPORT_FULL_32
SYS_EXPORT_FULL_31
SYS_EXPORT_FULL_33
SYS_EXPORT_FULL_35
SYS_EXPORT_FULL_36
SYS_EXPORT_FULL_37
SYS_EXPORT_FULL_38
SYS_EXPORT_FULL_39
SYS_EXPORT_FULL_03

TABLE_NAME
------------------------------
SYS_EXPORT_FULL_40
SYS_EXPORT_FULL_41
SYS_EXPORT_FULL_43
SYS_EXPORT_FULL_42
SYS_EXPORT_FULL_24
SYS_EXPORT_FULL_28
SYS_EXPORT_FULL_30
SYS_EXPORT_FULL_34
MLOG$_T1
T1
SYS_EXPORT_FULL_44

TABLE_NAME
------------------------------
SYS_EXPORT_FULL_46
SYS_EXPORT_FULL_47
SYS_EXPORT_FULL_45
SYS_EXPORT_FULL_17
SYS_EXPORT_FULL_21
SYS_EXPORT_FULL_22
SYS_EXPORT_FULL_29
SYS_EXPORT_FULL_27
SYS_EXPORT_FULL_25
SYS_EXPORT_FULL_23
SYS_EXPORT_FULL_26

TABLE_NAME
------------------------------
SYS_EXPORT_FULL_16
SYS_EXPORT_FULL_02
SYS_EXPORT_FULL_19
SYS_EXPORT_FULL_20
SYS_EXPORT_FULL_11
SYS_EXPORT_FULL_15
RUPD$_T1

40 rows selected.

SQL> select MASTER, LOG_TABLE from USER_MVIEW_LOGS;

MASTER                   LOG_TABLE
------------------------------ ------------------------------
T1                   MLOG$_T1

SQL> select * from USER_MVIEW_LOGS;

LOG_OWNER               MASTER
------------------------------ ------------------------------
LOG_TABLE               LOG_TRIGGER              ROW PRI OBJ FIL
------------------------------ ------------------------------ --- --- --- ---
SEQ INC
--- ---
MANJIT                   T1
MLOG$_T1                              NO  YES NO  NO
NO  NO


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

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


SQL>