REFERENTIAL INTEGRITY and LOCKING
copy from http://www.myoracleguide.com/xl/REFERENTIAL_INTEGRITY_and_LOCKING.htm[@more@]This bulletin explains what referential integrity means andhow locking takes place with tables joined by the referential integrityrule. In addition, this bulletin explains how inserting/updating/deleting onetable can cause another table to get locked.REFERENTIAL INTEGRITY: is a rule defined on a column (or set of columns) in onetable that allows the insert or update of a row only if the value for the columnor