Question On CN Materialized View Logs (Doc ID 2307330.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

Query about the materialized view logs that should be present for CN in 11.5.10.2.

> select owner, segment_name, segment_type, bytes/1024/1024/1024 GB from dba_segments where segment_name like 'MLOG$_CN%';

OWNER SEGMENT_NAME SEGMENT_TYPE GB
------------------ ------------------------------ ------------------ ----------
CN MLOG$_CN_SCA_COND_DETAILS_ TABLE .00012207
CN MLOG$_CN_SCA_DENORM_RULES_ TABLE .00012207
CN MLOG$_CN_SCA_CONDITIONS_AL TABLE .00012207
CN MLOG$_CN_COMMISSION_HEADER TABLE 20.1103516
CN MLOG$_CN_COMMISSION_LINES_ TABLE 36.944458

Provide some information about above MLOG$ tables. What are they, their source etc..?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms