In this Document
APPLIES TO:
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
GOAL
How to handle MLOG$_AP_SUPPLIER_SITES_AL, MLOG$_AP_SUPPLIERS growing so much?
Both have lots of data.
SOLUTION
Refer to Bug 8614157 , there are two options:
1. Periodically truncating the log tables:
Please watch the growth of the log tables periodically and truncate them whenever they reach the limit.
2. Dropping the log tables:
If you do not use any DBI -- Oracle Daily Business Intelligence, you can drop snapshot log tables:
SQL> drop materialized view log on AP.AP_SUPPLIERS;
SQL> drop materialized view log on AP.AP_SUPPLIER_SITES_ALL;
REFERENCES
BUG:8614157 - MLOG$_AP_SUPPLIER_SITES_AL GROWING LARGE QUICKLY