QSM-02163: cannot use object id columns from materialized
view log



QSM-02163: cannot use object id columns from materialized view log..

Answer / guest

Cause: The materialized view log either does not have object
id columns logged, or the timestamp associated with the
object id columns is more recent than the last refresh time.

Action: A complete refresh is required before the next fast
refresh. Add object id columns to the materialized view log,
if required.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00112: end-of-line in quoted identifier

1 Answers  


ORA-14113: partitioned table cannot have column with LOB datatype

1 Answers  


ORA-12416: policy string not found

1 Answers  


TNS-12540: TNS:internal limit restriction exceeded

1 Answers  


TNS-01052: The command completed successfully

1 Answers  






ORA-38732: Expected file size string does not match string.

1 Answers  


ORA-16706: no resource guard is available

1 Answers  


ORA-01633: Real Application Clusters Option needed for this operation

1 Answers  


ORA-16080: invalid LogMiner session string for APPLY

1 Answers  


NNL-00001: request argument "string" is invalid

1 Answers  


ORA-04010: the number of values to CACHE must be greater than 1

1 Answers  


QSM-01091: cost based optimizer found query rewrite is more expensive

1 Answers  


Categories