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

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

Question Posted / guest

1 Answers
3488 Views
I also Faced
E-Mail Answers

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-31662: metadata transform name can not be defaulted

1 Answers

ORA-31052: Cannot delete ACL with other references

1 Answers

ORA-02879: sou2o: Could not gain access to protected memory

1 Answers

ORA-30391: the specified rewrite equivalence does not exist

1 Answers

PLS-00253: Formal parameter string missing in the parameters clause

1 Answers

ORA-12540: TNS:internal limit restriction exceeded

1 Answers

ORA-13270: OCI error string

1 Answers

ORA-01320: Invalid Logminer dictionar attribute

1 Answers

ORA-24079: invalid name string, names with AQ$_ prefix are not valid for string

1 Answers

PCB-00633: Invalid host variable and attribute pairing

1 Answers

QSM-02067: no partition key or PMARKER or join dependent expression in select list

1 Answers

ORA-16720: no available LOG_ARCHIVE_DEST_n parameters to use

1 Answers

For more Oracle Errors Interview Questions Click Here