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

RMAN-08541: channel string: SPFILE restore from autobackup complete

1 Answers  


ORA-24192: the property name cannot be null

1 Answers  


RMAN-06213: --------------- ---------------------------------------------------

1 Answers  


RMAN-06011: invalid level specified: number

1 Answers  


EXP-00025: dictionary shows no column for constraint string.number

1 Answers  






ORA-22132: hexadecimal string does not correspond to a valid REF

1 Answers  


ORA-36202: (XSAGOP01) 'number' is not a valid aggregation operator.

1 Answers  


NNL-00266: Round trip time is string

1 Answers  


ORA-13193: failed to allocate space for geometry

1 Answers  


ORA-22153: source variable-length array is not initialized

1 Answers  


KUP-03012: OCI error getting database column precision.

1 Answers  


ORA-02150: invalid new tablespace name

1 Answers  


Categories