Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02175: some query block in UNION ALL MV is not fast
refreshable
- 1 Answers
- 2876 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 |
DRG-11729: phrase does not have any narrower terms of this type
ORA-08274: Out of memory for environment variable
NNL-00517: Insert-replaces a data item under an existing name
TNS-01034: Uptime number days number hr. number min. number sec
PLS-00584: size of an opaque type must be between 1 and 4000 bytes
PLS-01900: : character to number conversion error
IMG-02012: 2FF12 - illegal specification for thumbnail generation
SQL*Loader-00271: Not a Parallel load. Table level OPTIONS statement ignored.
ORA-01136: specified size of file string (string blocks) is less than original size of string blocks
TNS-03501: OK
ORA-31110: Action failed as resource string is locked by name
ORA-31465: cannot obtain a lock on the subscription
Oracle Errors 
