ORA-12015: cannot create a fast refresh materialized view
from a complex query



ORA-12015: cannot create a fast refresh materialized view from a complex query..

Answer / guest

Cause: Neither ROWIDs and nor primary key constraints are
supported for complex queries.

Action: Reissue the command with the REFRESH FORCE or
REFRESH COMPLETE option or create a simple materialized view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28788: user provided invalid information, or an unknown error

1 Answers  


ORA-33054: (XSAGDNGL26) In AGGMAP workspace object, a MIN argument of number must be less than a FLOOR argument of number.

1 Answers  


ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

3 Answers  


QSM-01055: Query Rewrite failed to allocate the necessary materialized view join graph

1 Answers  


ORA-12004: REFRESH FAST cannot be used for materialized view "string"."string"

1 Answers  


ORA-39116: invalid trigger operation on mutating table string.string

1 Answers  


ORA-13380: network not found

1 Answers  


ORA-22974: missing WITH OBJECT OID clause

1 Answers  


ORA-25964: column type incompatible with join column type

1 Answers  


ORA-24384: Application context size is not initialized

1 Answers  


RMAN-08011: including current controlfile in backupset

1 Answers  


PLS-00155: Only a function may be a MAP, ORDER or CONSTRUCTOR method.

1 Answers  


Categories