QSM-01081: no primary key or row id found for table, string,
in MV, string



QSM-01081: no primary key or row id found for table, string, in MV, string..

Answer / guest

Cause: In order to obtain a missing column, the materialized
view needs to join back to the above table. But it lacks the
primary key or rowid for the table.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08309: sllfop: Cannot fstat file

1 Answers  


ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.

1 Answers  


KUP-04007: end of file reached

1 Answers  


DRG-10015: id exceeds limit(2147483642) of a number

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  






TNS-12518: TNS:listener could not hand off client connection

1 Answers  


ORA-15095: reached maximum ASM file size (string GB)

1 Answers  


ORA-32637: Self cyclic rule in sequential order MODEL

1 Answers  


PLS-00318: type "string" is malformed because it is a non-REF mutually recursive type

1 Answers  


ORA-36735: A value exceeded the MAX specification

1 Answers  


ORA-23478: object group "string" is already mastered at string

1 Answers  


ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string

1 Answers  


Categories