Oracle Error ORA-42031: interim table cannot have a commit SCN-based MV log defined on it

Oracle Error Message

ORA-42031: interim table cannot have a commit SCN-based MV log defined on it

Reason for the Error

An attempt was made to use an interim table which had a commit SCN-based materialzed view log defined on it.

Solution

Ensure that the interim table does not have a commit SCN-based materialzed view log defined on it.