Re: partition tables

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 01 Apr 2004 18:32:27 GMT
Message-ID: <%eZac.4444$hH3.1754@edtnps84>

Cupofjava1961 wrote:

> Can someone explain why a partitioned table cannot
> be moved at one time to another tablespace in Oracle 8i.
> Apparently from what I read the partitions have to be
> moved individually and the author left out the reason why.
>
>
> Thanks

Ummmm ... perhaps because each partition is defined individually; each can be in it's own tablespace; there is no requirement (by Oracle) to have all partitions in the same tablespace; and a parittion is a 'base unit of management'? Received on Thu Apr 01 2004 - 12:32:27 CST