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

PCB-00108: Unable to open list file "string"

1 Answers  


ORA-39030: invalid file type string

1 Answers  


ORA-09342: Detached process terminated by Oracle during shutdown abort

2 Answers  


ORA-19666: cannot do incremental restore of the controlfile

1 Answers  


ORA-31030: Unable to retrieve XML document

1 Answers  






NZE-28750: unknown error

1 Answers  


PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

1 Answers  


RMAN-06201: Deleted string objects

1 Answers  


ORA-00336: log file size string blocks is less than minimum string blocks

1 Answers  


ORA-16798: Unable to complete terminal recovery on the standby

1 Answers  


PLS-00522: MAP methods must return a scalar type.

1 Answers  


ORA-31423: change table string does not contain column string

1 Answers  


Categories