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-02282: duplicate or conflicting ORDER/NOORDER specifications

1 Answers  


ORA-13049: unable to determine tolerance value from table <layer>_SDODIM

1 Answers  


QSM-02066: Oracle error: see RELATED_NUM and RELATED_TEXT for details

1 Answers  


QSM-01582: Joining equivalence, string, with table, string, not possible

1 Answers  


ORA-01154: database busy. Open, close, mount, and dismount not allowed now

1 Answers  


ORA-24335: cannot support more than 1000 columns

1 Answers  


ORA-24435: Invalid Service Context specified.

1 Answers  


ORA-26098: direct path context is not prepared

1 Answers   IBM,


ORA-19574: output filename must be specified

1 Answers  


PROC-00014: Unknown error occurred

1 Answers  


PROC-00004: The cluster registry key to be operated on does not exist.

1 Answers  


PCC-02367: This indicator variable must be declared as type short

1 Answers  


Categories