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 |
TNS-00110: Could not initialize network from file TNSNET.ORA
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
ORA-01913: EXCLUSIVE keyword expected
LSX-00105: duplicate attribute group "~S"
ORA-32738: Hang analysis aborted due to failed memory copy
ORA-24781: branches don't belong to the same global transaction
ORA-22925: operation would exceed maximum size allowed for a LOB value
ORA-30085: syntax error was found in overlaps predicate
ORA-01983: invalid auditing option for DEFAULT
QSM-01073: materialized view, string, has a join not found in query
DRG-52200: invalid state during export
AMD-00114: PROCEDURE string, internal error