Oracle Error ORA-12082: “string”.”string” cannot be index organized

Oracle 40 Views 0 Min Read

Oracle Error Message

ORA-12082: “string”.”string” cannot be index organized

Reason for the Error

An attempt was made to create an index-organized materialized aggregate view or an index-organized updatable ROWID materialized view. This is not supported.

Solution

Try to create the materialized view without the index organization clause.

Tags: