ORA-12015: cannot create a fast refresh materialized view
from a complex query
- 1 Answers
- 5921 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-31634: job already exists
ORA-19755: could not open change tracking file
ORA-02065: illegal option for ALTER SYSTEM
PLS-00730: collection element type does not allow modifications
TNS-04201: Trace Assistant Usage ERROR: Missing File name
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
ORA-39091: unable to determine logical standby and streams status
QSM-01078: materialized view, string, is marked invalid
TNS-12166: TNS:Client can not connect to HO agent.
ORA-02271: table does not have such constraint
EXP-00043: Invalid data dictionary information in the row where column "string" is "string" in table string
NID-00107: File I/O error on datafile "string" during string operation (number/string)
Oracle Errors 
