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-07499: spglk: Cannot reschedule.

1 Answers  


ORA-26662: unable to process STREAMS Data Dictonary information for object

1 Answers  


RMAN-04010: target database Password:

1 Answers  


ORA-01576: The instance string is not enabled

1 Answers  


NNL-00285: Server has no queued system queries

1 Answers  


ORA-28501: communication error on heterogeneous database link

1 Answers  


ORA-08197: Flashback Table operation is not supported on clustered tables

1 Answers  


ORA-29813: non-supported object type with associate statement

1 Answers  


TNS-00293: Trace File Name : string

1 Answers  


ORA-00608: testing error [string] [string] [string] [string] [string]

1 Answers  


ORA-33429: (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.

1 Answers  


RMAN-06487: changed proxy copy expired

1 Answers  


Categories