Re: truncate partition table causes high latch free

From: Eagle Fan <eagle.f_at_gmail.com>
Date: 12 Apr 2006 02:54:04 -0700
Message-ID: <1144835644.406147.247130@e56g2000cwe.googlegroups.com>

Thanks for your reply.

I think "truncate partition" doesn't lock the whole table.

test case is very simple:
Session A inserted in one partition and then Session B truncated another partition and Session B can be done successfully.

>From the drop-split partition method,it will also need to hold the
"library cache pin" in exclusive mode.

Did you try to use "exchange partition" to do this before? I think it will be better than drop/split partiton:)

thanks for your reply again Received on Wed Apr 12 2006 - 04:54:04 CDT