Why CLOB segment size is growing
I am taking backup of a table T1 having LONG col into table T2 having CLOB ie
Desc T1;
Name Null? Type
----------------------------------------- -------- ----------------------------
SUBMITTER VARCHAR2(30 CHAR)
STATUS NOT NULL NUMBER(15)
BODY LONG
Desc T2;
Name Null? Type
----------------------------------------- -------- ----------------------------
SUBMITTER VARCHAR2(30 CHAR)
STATUS NOT NULL NUMBER(15)
BODY CLOB
insert into T2 select SUBMITTER,STATUS,to_lob(BODY) from T1;
1556215 rows inserted.
size of a T1 is 7.9 GB
size of a T2 is 6.6 GB
size of a CLOB segment SYS_LOB0000105137C00007$$ showing 20 GB
if im only copying data from one table to another then it should not exceed more than source table (T1) size
Why CLOB segment size is showing 20 GB ?
for any other info pls reply .. Thx