Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-06431: ssaio: Invalid Block number

1 Answers  


VID-00706: unsupported or corrupted input format

1 Answers  


ORA-23325: parameter type is not string

1 Answers  


ORA-39957: invalid warning category

1 Answers  


ORA-22881: dangling REF

1 Answers  






RMAN-06561: available space must be larger than number kb

1 Answers  


LPX-00220: the string "]]>" cannot occur in character data

1 Answers  


TNS-02521: encryption/crypto-checksumming: Diffie-Hellman seed too small

1 Answers  


ORA-13766: A ranking measure is required.

1 Answers  


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

0 Answers   Olivetti,


ORA-09813: Unable to get directory status

1 Answers  


NNL-00254: Server-generated requests currently do not request forwarding

1 Answers  






Categories