QSM-02175: some query block in UNION ALL MV is not fast
refreshable
- 1 Answers
- 2159 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: For a materialized view with UNION ALL to be fast
refreshable, each query block must conform to a fast
refreshable materialized join view or materialized aggregate
view.
Action: Check each query block in the UNION ALL to ensure it
is either a materialized view with joins or aggregates.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
TNS-00246: Connection Manager: Failed to start tracing
DRG-11816: Use Proxy
ORA-29272: initialization failed
ORA-38719: Invalid DUMP FLASHBACK object.
ORA-17503: ksfdopn:string Failed to open file string
ORA-02181: invalid option to ROLLBACK WORK
QSM-00502: OCI error
RMAN-10001: error parsing recovery catalog connect string "string"
TNS-12639: Authentication service negotiation failed
ORA-25216: invalid recipient, either NAME or ADDRESS must be specified
SQL*Loader-00269: Null string not allowed as clause comparison text.
NNL-00526: Starts a server using a non-standard executable and optional arguments
Oracle Errors 
