Home » SQL & PL/SQL » SQL & PL/SQL » Size of a clob [Split message]
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 Shocked

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 ?
Previous Topic: Group By clause and sum(sal) (2 threads merged by bb)
Next Topic: how to generate one id for 'x' number of records in a single sql query
Goto Forum:
  


Current Time: Wed Dec 07 22:21:01 CST 2016

Total time taken to generate the page: 0.09072 seconds