Index on detail table is locked while inserting into master table
Hello,
I have such problem with master-detail tables. Here is the example. Table TMP_MASTER is filled by application user, but TMP_DETAIL is maintained by background process which generates some data connected to TMP_MASTER data.
Database version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit on Linux
CREATE TABLE tmp_master (mast_id NUMBER PRIMARY KEY, opis VARCHAR2(30));
CREATE TABLE tmp_detail (det_id NUMBER PRIMARY KEY, mast_det_id NUMBER, opis VARCHAR2(30)
,CONSTRAINT tdet_tmas_fk FOREIGN KEY (mast_det_id) REFERENCES tmp_master(mast_id)
);
CREATE INDEX tmp_tdet_mast_det_fk_i ON tmp_detail (mast_det_id)
I have such problem with master-detail tables. Here is the example. Table TMP_MASTER is filled by application user, but TMP_DETAIL is maintained by background process which generates some data connected to TMP_MASTER data.
Database version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit on Linux
CREATE TABLE tmp_master (mast_id NUMBER PRIMARY KEY, opis VARCHAR2(30));
CREATE TABLE tmp_detail (det_id NUMBER PRIMARY KEY, mast_det_id NUMBER, opis VARCHAR2(30)
,CONSTRAINT tdet_tmas_fk FOREIGN KEY (mast_det_id) REFERENCES tmp_master(mast_id)
);
CREATE INDEX tmp_tdet_mast_det_fk_i ON tmp_detail (mast_det_id)
0