Wednesday 15 February 2012

ORA-12017: cannot alter primary key mview string to a rowid mview

ORA-12017: cannot alter primary key mview string to a rowid mview

Cause: An attempt was made to convert the primary key of a materialized view to a ROWID materialized view.

Action: Conversion of a primary key materialized view to a ROWID materialized view is not supported. Create a new materialized view with ROWIDs or drop and recreate the materialized view with ROWIDs.

No comments:

Post a Comment