QSM-01106: MV, string, is stale with respect to some
partition(s) in the base table(s)



QSM-01106: MV, string, is stale with respect to some partition(s) in the base table(s)..

Answer / guest

Cause: Query is requesting some data from the MV that are
stale with respect to some partitions in the base tables due
to some updates.

Action: refresh the stale partitions and rerun the query

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07599: spwat: $SCHDWK failure

1 Answers  


NNL-00018: warning: could not contact default name server

1 Answers  


ORA-24056: internal inconsistency for QUEUE string and destination string

1 Answers  


ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.

1 Answers  


TNS-01001: start [<listener_name>] : start listener

1 Answers  






ORA-19505: failed to identify file "string"

1 Answers  


ORA-36403: (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.

1 Answers  


ORA-17507: I/O request size string is not a multiple of logical block size

1 Answers  


ORA-07410: slpdtb: number too large for supplied buffer.

1 Answers  


ORA-15029: disk 'string' is already mounted by this instance

1 Answers  


NZE-29240: the cryptographic engine does not recognize the algorithm

1 Answers  


NNO-00623: setting auto-refresh retry interval to number seconds

1 Answers  


Categories