create table xxx as select * from yyy; drop yyy, rename xxx to yyy and rebuild your indexes - with those tiny tables it wont take any time at all
On 22/07/07, vikram singh <vikramsingh120@gmail.com> wrote:
What are the various ways i have to collapse partitions in a DB?