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

LSX-00136: "maxOccurs" is less than "minOccurs"

1 Answers  


ORA-28660: Partitioned Index-Organized table may not be MOVEd as a whole

1 Answers  


DRG-11624: invalid attribute string for string: proper range string to string

1 Answers  


ORA-12590: TNS:no I/O buffer

1 Answers  


PCC-02362: Host variable not declared within SQL DECLARE section

1 Answers  






ORA-12818: invalid option in PARALLEL clause

1 Answers  


O2I-00115: Error opening the HFILE file

1 Answers  


TNS-01054: Contacted the listener successfully

1 Answers  


ORA-32316: REFRESH FAST of "string"."string" unsupported after mixed DML

1 Answers  


ORA-13761: invalid filter

1 Answers  


ORA-29284: file read error

1 Answers  


ORA-30728: maximum number of columns exceeded

1 Answers  


Categories