Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-29537: class or resource cannot be created or dropped directly

1 Answers  


ORA-00267: name of archived log file not needed

1 Answers  


ORA-23607: invalid column "string"

1 Answers  


ORA-19211: column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type

1 Answers  


QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

1 Answers  






ORA-13628: Insufficient privileges to access the task belonging to user string

1 Answers  


ORA-06401: NETCMN: invalid driver designator

1 Answers  


LPX-00263: couldn't connect to host ~s port ~d

1 Answers  


ORA-28535: invalid Heterogeneous Services context

1 Answers  


NNL-00505: log_stats [<server_list>] : write Names server statistics to the log file

1 Answers  


ORA-23452: flavor string of object group "string"."string" is already published

1 Answers  


ORA-16047: DGID mismatch between destination setting and standby

1 Answers  






Categories