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-01052: referential integrity constraint on table,
string, not VALID in ENFORCED integrity mode



QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode..

Answer / guest

Cause: A join present in the materialized view requires
validated primary/foreign key constraints in ENFORCED query
rewrite integrity mode.

Action: Validate the constraint or change the integrity mode
with ALTER SESSION SET 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

EXP-00105: parameter string is not supported for this user

1 Answers  


ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)

1 Answers  


ORA-16032: parameter string destination string cannot be translated

1 Answers  


TNS-00127: Missing Connection Manager name in TNSNET.ORA

1 Answers  


ORA-07592: sspgprv: Error obtaining required privileges

1 Answers  


PCC-02319: expression type does not match usage

1 Answers  


ORA-27037: unable to obtain file status

1 Answers  


ORA-19649: offline-range record recid string stamp string not found in file string

1 Answers  


PLS-00583: size must be specified if opaque type is fixed-length

1 Answers  


ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


PLS-00239: invalid external type specification for SQLCODE

1 Answers  


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

1 Answers  


Categories