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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12648: Encryption or data integrity algorithm list empty

1 Answers  


QSM-02055: mv references a packed object table or view

1 Answers  


ORA-03205: partition name is required when partitioned type is specified

1 Answers  


ORA-09774: osnmui: cannot send break message

1 Answers  


ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'

1 Answers  






ORA-12566: TNS:protocol error

1 Answers  


PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables "string"

1 Answers  


ORA-06009: NETASY: dialogue filename too long

1 Answers  


ORA-01636: rollback segment 'string' is already online

1 Answers  


ORA-28650: Primary index on an IOT cannot be rebuilt

1 Answers  


ORA-01275: Operation string is not allowed if standby file management is automatic.

1 Answers  


ORA-02705: osnpol: polling of communication channel failed

1 Answers  


Categories