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

ORA-16561: Cannot remove an active instance.

1 Answers  


RMAN-06117: cannot do DELETE EXPIRED on an object which is not expired

1 Answers  


ORA-34358: (MXDSS14) number other users reading

1 Answers  


ORA-13349: polygon boundary crosses itself

1 Answers  


ORA-29807: specified operator does not exist

1 Answers  


NZE-28837: no wallet descriptor

1 Answers  


TNS-00201: Unable to read answer connection data :string:

1 Answers  


IMG-00585: output format does not support the specified channelOrder

1 Answers  


ORA-16722: unable to set LOG_ARCHIVE_DEST_STATE_n parameters

1 Answers  


NID-00101: LOGFILE (string) not accessible

1 Answers  


ORA-25156: old style outer join (+) cannot be used with ANSI joins

1 Answers  


TNS-01103: Protocol specific component of the address is incorrectly specified

1 Answers  


Categories