Re: Question about Partitioning

From: Remco <choco_at_nospam.freeler.nl>
Date: Fri, 17 Feb 2006 11:01:31 +0100
Message-ID: <43f59eb5$0$27696$ba620dc5@nova.planet.nl>

"G Quesnel" wrote
> Just a couple of ideas...
> Once you have truncated a partition,
> could you not merge it with the one beside it, or drop it ?
> Then you could create a new partition with whatever name you want.
> Instead of a move partition, why not do a drop and create new ?
>
> Would that help ?
>

Ideally I would like to create a rotation of partitions, and keep them in there
own tablespaces. We are talking about 100+ tables which are all partitioned the same way as I described.

I think merging isn't the best solutions dropping and recreating is possible but
you have to determine in what tablespace the partition is before dropping it.

Any other suggestions would be great

Thx Again Received on Fri Feb 17 2006 - 04:01:31 CST