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
- 6704 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 |
SQL*Loader-00961: Error calling once/load finishing for table string
ORA-00238: operation would reuse a filename that is part of the database
NNL-00569: domain_hint <domain_name> <NS_name> <NS_Addr> : Provide hint of a nameserver for a given domain
NNO-00712: warning: group string cache checkpoint failed
NZE-28784: file name translation failure
ORA-27057: cannot perform async I/O to file
TNS-00018: INTCTL: TNS_ADMIN not defined
ORA-32302: object materialized views must be object ID based
LPX-00001: NULL pointer
ORA-01871: the number of seconds must be less than 60
ORA-01647: tablespace 'string' is read only, cannot allocate space in it
PCC-02106: Userid only used when SQLCHECK = FULL, userid ignored.
Oracle Errors 
