Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


QSM-01031: materialized view, string, is stale in TRUSTED
integrity mode



QSM-01031: materialized view, string, is stale in TRUSTED integrity mode..

Answer / guest

Cause: A stale materialized view cannot be used for query
rewrite when the query rewrite integrity mode is set to TRUSTED.

Action: Refresh the materialized view or alter the rewrite
integrity mode with ALTER SESSION QUERY_REWRITE_INTEGRITY =
STALE TOLERATED command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19729: File string is not the initial version of the plugged in datafile

1 Answers  


DRG-13300: document size bigger than string bytes

1 Answers  


LFI-01006: File ends in partial character in string.

1 Answers  


LPX-00223: external entity "~s" found in an attribute value

1 Answers  


NNO-00073: loading server config from region database

1 Answers  


ORA-36904: (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.

1 Answers  


RMAN-06045: LEVEL option not supported for archive log or current/standby controlfile copies

1 Answers  


ORA-22879: cannot use the LOB INDEX clause for partitioned tables

1 Answers  


TNS-00260: -------------------------------------------------------------------

1 Answers  


KUP-04043: table column not found in external source: string

1 Answers  


ORA-00001: unique constraint (string.string) violated

1 Answers  


ORA-28107: policy was disabled

1 Answers  


Categories