 |
|
Oracle Replication Tips by Burleson |
Oracle materialized view mlog$ table
The mlogs$_<table_name>
is the materialized view log created with the CREATE MATERIALIZED
VIEW LOG
command. Note that materialized view log tables using primary keys also
have rupd$_
tables, as is the case in this example. The rupd$_
table supports updateable materialized views (covered in Chapter
4), which are only possible on log tables with primary keys.
The materialized view logs are just like any other table and can be
queried.
SQL> desc mlog$_bonus;
Name Null? Type
---------------------------- -------- -------------
M_ROW$$ VARCHAR2(255)
SNAPTIME$$ DATE
DMLTYPE$$ VARCHAR2(1)
OLD_NEW$$ VARCHAR2(1)
CHANGE_VECTOR$$ RAW(255)
Execute a select count(*) to determine whether there are changes
waiting to propagate.
SQL> select count(*) from mlog$_bonus;
COUNT(*)
----------
0
This is an
excerpt from Oracle Replication By Rampant TechPress (only $19.95).
You can click here to order a copy and get instant access to the code
depot:
http://www.rampant-books.com/book_2003_2_replication.htm
Get a Personal Oracle
Replication Mentor
The author is now offering personal mentors for
Oracle DBAs where you can have an Oracle expert right at your
fingertips, anytime day or night. We work with hundreds of Oracle
databases every year, so we know exactly how to quickly assist you
with any Oracle replication question.
You can get me personally, or any Oracle Certified replication DBA
with more than 20 years of full-time IT experience.

|