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

KUP-04108: unable to reread file string

1 Answers  


PLS-00427: RPC defaults cannot use builtins when versions of STANDARD differ

1 Answers  


ORA-02704: osndopop: fork failed

1 Answers  


PCB-00701: MAX OCCURRANCES must be between 1 and 65535

1 Answers  


ORA-19026: EXTRACTVALUE can only retrieve value of leaf node

1 Answers  






ORA-38737: Expected sequence number string doesn't match string

1 Answers  


RMAN-08018: channel string: starting archive log restore to user-specified destination

1 Answers  


ORA-02085: database link string connects to string

1 Answers  


ORA-19637: backupPieceCreate requires file name when using DISK device

1 Answers  


ORA-23385: replication parallel push string argument not valid

1 Answers  


RMAN-06112: changed datafile copy available

1 Answers  


NNC-00407: alias loop in name request

1 Answers  


Categories