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