Showing posts with label ORA-12017. Show all posts
Showing posts with label ORA-12017. Show all posts

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.