Database Administration (MOSC)

MOSC Banner

Index on detail table is locked while inserting into master table

edited Jan 20, 2010 8:41PM in Database Administration (MOSC) 4 commentsAnswered
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center