|
Hi I have master table A, inherited by Table B and Table C Table B has data for June 18 Table C has data for June 19 The application issues queries against the master table…on
June 19, there is no reference to data from June 18 tables. When I issue a truncate table B, it appears to take a lock
on master table A (this is evident as other inserts to the table are in a
WAITING state), and the ps listing shows the truncate table in a WAIT state
(along with the INSERTS) Does the truncation of a child table take a lock on the
master table ? and if so, why does it go in a WAIT state |
