QSM-02123: subquery and UNION mv's must be primary key mv's
Answer / guest
Cause: The capability in question is not supported when the
materialized view is not a primary key materialized view and
uses subqueries or the union operator in this context.
Action: Re-create the materialized view as a primary key
materialized view.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
SQL*Loader-00125: specified value for readsize(number) less than max_record_size(number)
ORA-27542: Failed to unprepare a buffer prepared for remote update
ORA-02713: osnprd: message receive failure
ORA-02245: invalid ROLLBACK SEGMENT name
PCB-00500: No EXEC SQL CONTEXT USE statement encountered
SQL*Loader-00254: Cannot have DISCARDFILE specs here when multiple data files
ORA-04940: unsupported optimization of Oracle binary, check alert log for more info
DRG-50802: failed to bind input
ORA-36991: (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
ORA-39500: failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
ORA-16502: the Data Guard broker operation succeeded with warnings
ORA-12471: Specified compartment or group is not authorized for user