Clever Geek Handbook

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

I have a table with a materialized view log created on it:

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 what table RUPD$_T1

is a table with mview logs for T1

?

I can define this for MLOG$_T1

:

select MASTER, LOG_TABLE from USER_MVIEW_LOGS

|T1       |MLOG$_T1 |

But where can you find the link to the table RUPD$_T1

?

+4


source to share


2 answers


its in the base SYS 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
+6


source


Try:



 select * from all_mview_logs
0


source






More articles:


All Articles