Size of a clob [Split message] [message #395300] |
Wed, 01 April 2009 01:58 |
indikishor
Messages: 1 Registered: March 2009
|
Junior Member |
|
|
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 T1 select SUBMITTER,STATUS,to_lob(BODY);
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 T1 size
Why CLOB segment size is showing 20 GB ?
|
|
|