Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12015: cannot create a fast refresh materialized view
from a complex query
- 1 Answers
- 6702 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-23501: refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
ORA-02817: Read failed
ORA-10630: Illegal syntax specified with SHRINK clause
ORA-14115: partition bound of partition number string is too long
SQL-02124: NULL value returned by EXEC TOOLS statement
RMAN-08109: channel string: restored block(s) from backup piece string
ORA-13501: Cannot drop SYSAUX tablespace
PROC-00024: Error in the messaging layer
RMAN-06575: platform id number found in datafile string header is not a valid platform id
NZE-28830: no identity type specified
ORA-27210: syntax error in device PARMS
ORA-01061: cannot start up a V8 server using a V7 client application
Oracle Errors 
