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-01121: materialized view, string, is TRUSTED in ENFORCED
integrity mode



QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode..

Answer / guest

Cause: A stale materialized view created with USING TRUSTED
CONSTRAINTS clause cannot be used when the query rewrite
integrity mode is set ENFORCED.

Action: Alter materialized view such that it has the
ENFORCED CONSTRAINTS ALTER MATERIALIZED VIEW <mv> REFRESH
USING ENFORCED CONSTRAINTS

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30030: suppress resumable related error message

1 Answers  


RMAN-08066: database reset to incarnation string

1 Answers  


DRG-11827: Request Timeout

1 Answers  


ORA-12163: TNS:connect descriptor is too long

1 Answers  


PLS-00457: expressions have to be of SQL types

1 Answers  


NNL-00010: error getting address for server "string"

1 Answers  


RMAN-06051: DELETE INPUT option not implemented yet

1 Answers  


ORA-29894: base or varray datatype does not exist

1 Answers  


ORA-29295: invalid mime header tag

1 Answers  


ORA-06042: NETDNT: message receive failure

1 Answers  


ORA-31090: invalid database schema name "string"

1 Answers  


ORA-31643: unable to close dump file "string"

1 Answers  


Categories