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
Comments
-
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 forT1
?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
?