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-20505: create datafile during recovery

1 Answers  


ORA-38952: Source database not 10.0.0.0 compatible

1 Answers  


ORA-27460: cannot execute disabled job "string.string"

1 Answers  


RMAN-06224: Automatic instance created

1 Answers  


ORA-13910: Parameter string cannot be NULL.

1 Answers  






ORA-08437: invalid picture type in picture mask

1 Answers  


ORA-19507: failed to retrieve sequential file, handle="string", parms="string"

1 Answers  


ORA-26001: Index string specified in SORTED INDEXES does not exist on table string

1 Answers  


QSM-02079: mv log must have ROWID

1 Answers  


NNL-00262: Request forwarding is currently disabled

1 Answers  


CLSR-00503: Error number encountered when creating an EVM event

1 Answers  


ORA-03208: partitioned type must be specified for a non-composite object

1 Answers  


Categories