Re: One Table records spanning across multiple Tablespaces

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 21 Jun 2005 13:48:00 +0200
Message-ID: <d98uph$8tf$1@news.BelWue.DE>

qazmlp1209_at_rediffmail.com wrote:
> 1.
> Is one Table records spanning across multiple Tablespaces is possible?
>
> 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?
>

That is a strange requirement. You put a segment into a tablespace, which itself is just a bunch of datafiles. Now if you have a table that consists of several segments (LOBs, Partitioning) then it can spann multiple Tablespaces depending on where the segments are placed.

Now instead of telling what the technical requirement allegedly is, would you care to share the business case?

Regards
Holger Received on Tue Jun 21 2005 - 06:48:00 CDT