table size after the split partition has increased from 40MB to 3308MB

Hi,

DWH_NRC table was of 40MB. i did a split partition activity on this table to split the table in multiple partitions. before the activity was started. size of this table was of 40MB as shown below.

select owner,segment_name,tablespace_name,sum(bytes)/1024/1024 from dba_segments where owner='CBS_OWNER' and segment_name='DWH_NRC' group by owner,segment_name,tablespace_name;

OWNER             SEGMENT_NAME          TABLESPACE_NAME        SUM(BYTES)/1024/1024

------------------------------ ------------------------------ ------------------------------ --------------------

CBS_OWNER           DWH_NRC            CUST_PROD_DAT                  40

But after the activity, size of this table increased to 3308MB.

select owner,segment_name,tablespace_name,sum(bytes)/1024/1024 from dba_segments where owner='CBS_OWNER' and segment_name='DWH_NRC' group by owner,segment_name,tablespace_name;