| Data insertion in LOBs cause table to Grow Rapidly [message #65649] |
Mon, 22 November 2004 18:36 |
Dipankar Bhattacharya
Messages: 4
Registered: October 2003
|
Junior Member |
|
|
Hi everyone.. I was trying to insert data from a table with LONG datatype into a NCLOB . Table with LONG column was around 1.5GB. Everything looked ok till I had inserted 100,000 records(1100 MB) or so , when the storage just shoots up , and table grows up by 3 GBs for the next 20,000 records . Can anyone please suggest something for this, is this a Data Storage problem ? These are the storage parameters of the LOB column in the table :
LOB (LOB_NOTES) STORE AS
( TABLESPACE G_DATA
ENABLE STORAGE IN ROW
CHUNK 8192
PCTVERSION 10
NOCACHE
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
Any suggestion would be of help...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
