0x10000000 This is a transient state that is only in effect during a data rebalancing operation. When new containers are added to a table space that is defined as database managed space (DMS), or existing containers are extended, a rebalancing of the table space data might occur.
Rebalancing is the process of moving table space extents from one location to another in an attempt to keep the data striped. An extent is a unit of container space (measured in pages), and a stripe is a layer of extents across the set of containers for a table space. Given load input file staffdata.del with a substantial amount of data (for example, 20000 or more records):
connect to sample;
create tablespace ts1 managed by database using (file '/home/melnyk/melnyk/NODE0000/SQL00001/ts1c1' 1024);
create table newstaff like staff in ts1;
load from staffdata.del of del insert into newstaff nonrecoverable;
alter tablespace ts1 add (file '/home/melnyk/melnyk/NODE0000/SQL00001/ts1c2' 1024);
select varchar(tbsp_name, 30) as tbsp_name, varchar(tbsp_state, 40) as tbsp_state from table(mon_get_tablespace('',-2)) as t;
Information returned for TS1 shows that this table space is in DMS Rebalance in Progress state.