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

PCB-00575: PLS-number: string

1 Answers  


ORA-21704: cannot terminate cache or connection without flushing first

1 Answers  


PCC-00045: %s clause inappropriate at line number in file string. Ignored.

1 Answers  


ORA-31403: change table string already contains a column string

1 Answers  


IMG-00577: invalid quantize argument

1 Answers  






ORA-02039: bind by value is not allowed for array type

1 Answers  


ORA-23493: "string" is not a new site for extension request "string"

1 Answers  


ORA-31415: change set string does not exist

1 Answers  


ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded

1 Answers  


PCC-00051: Size of VARCHAR string is larger than 65533 in line number in file string

1 Answers  


ORA-19566: exceeded limit of string corrupt blocks for file string

1 Answers  


PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)

1 Answers  


Categories