QSM-02180: no primary key constraint in the master table
Answer / guest
Cause: The explain_mview assumes that the materialized view
is going to be created as the Primary Key materialized view.
A Primary Key materialized view can not be created if the
base table does not have a primary key constraint.
Action: Add a primary key constraint to the base table, or
create the materialized view as Rowid MV by specifying the
WITH ROWID option. If the materialized view is a Rowid MV,
then it should be able to do complete refresh and even fast
refresh, given that the materialized view log on the master
table has a rowid.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
EXP-00058: Password Verify Function for string profile does not exist
ORA-26667: invalid STREAMS parameter string
ORA-38441: System could not derive the list of STORED and INDEXED attributes.
ORA-09762: sNeXT_instanceName: translation error.
QSM-02031: materialized view cannot support any type of query rewrite
ORA-21609: memory being resized without being allocated first
RMAN-20039: format requires character when duplexing
PCC-00141: Thread Safety is not implemented in this precompiler
PLS-00588: unqualified instance attribute references allowed only in member methods
NNL-00506: reset_stats [<server_list>] : reset Names server statistics
ORA-22347: No changes to type specified for ALTER TYPE
RMAN-06159: error while looking up backup set