QSM-01082: Joining materialized view, string, with table,
string, not possible



QSM-01082: Joining materialized view, string, with table, string, not possible..

Answer / guest

Cause: A column in the query is not found in the summary. To
obtain the column, a join back of materialized view to the
table by means of either the primary key, foreign key or
rowid of the table is required. The specified materialized
view does not have the primary key, foreign key or rowid of
the table to perform the join operation.

Action: Consider building a dimension-table to provide the
missing information.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28025: missing or null external name

1 Answers  


NZE-28810: Cannot create key descriptor.

1 Answers  


ORA-01340: NLS error

1 Answers  


NNL-00298: No cache dump currently scheduled

1 Answers  


KUP-02002: unexpected end of input file reached

1 Answers  






ORA-12554: TNS:current operation is still in progress

1 Answers  


NNL-01075: Contact string

1 Answers  


TNS-00269: OFF

1 Answers  


ORA-22321: method does not return any result

1 Answers  


RMAN-06447: changed proxy copy available

1 Answers  


ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition

1 Answers  


ORA-07682: sou2os: set kernel dispatch fail err

1 Answers  


Categories