Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table locking problem
This is the parent table for all of the rest of non configuration tables.
By this I mean that of the 53 tables in the schema, 16 of them contain case
information all of which have a foreign key relationionship back to this
(the case table) central table. this is a pretty heavily indexed table, but
inserts only happen on it 2000-3000 times a day, it is updated but not that
frequently. Most of the function of this system is accounting and tracking.
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
news:vcbm8.80838$af7.50640_at_rwcrnsc53...
> Is the table you are doing an insert into a child table and no index on
the
> foreign key?
> Jim
Received on Wed Mar 20 2002 - 20:46:01 CST