Re: MTL_ITEM_CAT_SN and DIRLOAD_DML

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/MTL-ITEM-CAT-SN-and-DIRLOAD-DML-tp1885p1895.html

So the problem is obvious.

The table MTL_ITEM_CATEGORIES has no primary key.
that's why the "Materialized View log" should be created on it is "with rowid", and it is created "with rowid", I checked it on my 12.2.4 system.

So, in this situation the "Materialized view" can be created without specificy the rowid clause, no error will be presented, but in that case Fast refresh will not be possible.

However, if the" Materialized view" is created with rowid caluse, then Fast refresh will be possible.

So, you can recrete APPS.MTL_ITEM_CATS_SN with rowid clause to make it fast refreshable.