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

ORA-39047: Jobs of type string cannot use multiple execution streams.

1 Answers  


ORA-24165: invalid rule engine object privilege: string

1 Answers  


ORA-16181: SGA specified for Logical Standby is too large

1 Answers  


RMAN-06168: no backup pieces with this tag found: string

1 Answers  


ORA-23414: materialized view log for "string"."string" does not record rowid values

1 Answers  


ORA-12511: TNS:service handler found but it is not accepting connections

1 Answers  


ORA-30932: Reference node 'string' not contained in specified parent node 'string'

1 Answers  


DRG-10704: preference string does not have an attribute named string

1 Answers  


ORA-33052: (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.

1 Answers  


ORA-19592: wrong string conversation type

1 Answers  


ORA-38475: The attribute set and the associated ADT are out of sync.

1 Answers  


RMAN-06151: datafile string creation scn string

1 Answers  


Categories