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