Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: One Table records spanning across multiple Tablespaces
qazmlp1209_at_rediffmail.com wrote:
> 1.
> Is one Table records spanning across multiple Tablespaces is possible?
Yes. Partitions of the same table can reside in different tablespaces.
> 2.
> We have a case where it is required to move data from one tablespace to
> 3 different/new tablespaces. There are millions of records exist. What
> is the best way of achieving this?
Partitioning. Cannot think offhand of any other method to do this specifically.
But using partitioning to "stripe" data across tablespaces does not sound to me like a great idea to address space issues. More like the old thing of fixing the symptoms and not the actual problem.
-- BillyReceived on Tue Jun 21 2005 - 05:33:51 CDT