Oracle Error ORA-12041: cannot record ROWIDs for index-organized table “string”.”string”

Oracle Error Message

ORA-12041: cannot record ROWIDs for index-organized table “string”.”string”

Reason for the Error

Index-organized tables do not have ROWIDs. Therefore a materialized view log that records the ROWIDs of an index-organized table could not be created.

Solution

Do not include the WITH ROWID option when using the CREATE MATERIALIZED VIEW command and do not include the ADD ROWID option when using the ALTER MATERIALIZED VIEW command if the master table is index-organized.