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-19507: failed to retrieve sequential file, handle="string", parms="string"

1 Answers  


LFI-00113: Unable to initialize the Standard File object string.

1 Answers  


PCB-00105: Included file name "string" exceeds name limit of number characters

1 Answers  


RMAN-06066: the target database must be mounted when issuing a RECOVER command

1 Answers  


NNO-00155: warning: hint number has missing address, hint ignored

1 Answers  






ORA-07671: $IDTOASC failed translating an integrity category

1 Answers  


ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  


ORA-25327: Array size is invalid

1 Answers  


QSM-01013: nested aggregates or CONNECT BY/START WITH clause present

1 Answers  


ORA-12683: encryption/crypto-checksumming: no Diffie-Hellman seed

1 Answers  


ORA-25185: index column other than last can not be specified for INCLUDE clause

1 Answers  


RMAN-06436: enter DROP CATALOG command again to confirm catalog removal

1 Answers  


Categories