QSM-02174: the materialized view does not have a UNION ALL
marker column
- 1 Answers
- 5030 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: For a materialized view with UNION ALL to be fast
refreshable, it must have a UNION ALL marker column. This is
a constant column, at the same ordinal position in each
query block and must have distinct values in each query block.
Action: Add a UNION ALL marker column to each query block in
the UNION ALL query defining the materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-27151: buffer not large enough to hold process ID string
ORA-38743: Time/SCN is in the future of the database.
ORA-06001: NETASY: port set-up failure
IMG-00606: unable to access image data
ORA-38419: invalid identifier in attribute : string
ORA-02453: duplicate HASH IS specification
ORA-25956: join index cannot be created on tables owned by SYS
RMAN-08120: WARNING: archive log not deleted, not yet applied by standby
DRG-12407: invalid CTX REPEAT tag attribute (string)
ORA-01881: timezone region id number is invalid
ORA-07449: sc: usnewlock failed.
ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified
Oracle Errors 
