CODEWITHSUNDEEP
sqloracle-databasedatabase-replicationmaterialized-views
turbanoff
turbanoff

Reputation: 2479

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

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?

Upvotes: 4

Views: 16656

Answers (2)

user11732454
user11732454

Reputation: 1

Try:

 select * from all_mview_logs

Upvotes: 0

DazzaL
DazzaL

Reputation: 21973

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

Upvotes: 6

Related Questions