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

QSM-01093: anti-join marker not found in materialized join view

1 Answers  


ORA-02081: database link is not open

1 Answers  


ORA-31161: element or attribute "string" cannot be stored out of line

1 Answers  


ORA-30101: unknown parameter name 'string'

1 Answers  


ORA-30161: A system error occurred during the OCIFile function call

1 Answers  


ORA-13451: GeoRaster metadata scaling function error

1 Answers  


TNS-12161: TNS:internal error: partial data received

1 Answers  


ORA-30485: missing ORDER BY expression in the window specification

1 Answers  


NNL-00245: General request processing is currently enabled

1 Answers  


ORA-22285: non-existent directory or file for string operation

1 Answers  


KUP-04091: little endian byte order mark found when big endian expected in string

1 Answers  


PLS-00719: only widening of attribute 'string' constraints is allowed

1 Answers  


Categories