ORA-12015: cannot create a fast refresh materialized view
from a complex query
- 1 Answers
- 6761 Views
- I also Faced
- E-Mail Answers
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 |
ORA-24276: function 'string' output 'string' maximum value exceeded
ORA-30555: global index partitioning key is an expression
ORA-16050: destination exceeded specified quota size
ORA-09312: slspool: error spooling file to printer
ORA-14101: partition extended table name cannot refer to a synonym
ORA-15111: conflicting or duplicate STRIPE options
ORA-01251: Unknown File Header Version read for file number string
ORA-07617: $FORMAT_CLASS failed translating the binary label to a string
DRG-11814: See Other
ORA-24026: operation failed, queue string.string has errors
ORA-30382: DROP MATERIALIZED VIEW string.string operation is not complete
NNL-00517: Insert-replaces a data item under an existing name
Oracle Errors 
