| Urgent CLOB [message #59573] |
Thu, 04 December 2003 06:02 |
avinash prabhu
Messages: 2
Registered: October 2003
|
Junior Member |
|
|
hi..
I have created f/wg tablespace and table containing clob type.
Whenever i insert +2000 records iget a error as unable to extend Lob Segment..
Pls tell me the cause and remedy for it?
This tablespace also contains other tables but they did not contain lot of data..
Urgently waiting for your reply..
***********Table and tablespace**************
create tablespace TS_AUD_GEN datafile
'/oradata/nsdl/ts_aud_gen.1' size 500M
extent management local
uniform size 10M;
DROP Table AUD_DTL_IMG_TBL CASCADE CONSTRAINTS;
CREATE TABLE AUD_DTL_IMG_TBL
(
TXN_NO NUMBER (9) NOT NULL,
SUB_SRL_NO NUMBER(9) NOT NULL,
OLD_VAL CLOB NOT NULL,
NEW_VAL CLOB NOT NULL
)
TABLESPACE TS_AUD_GEN
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 1000
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
LOB (OLD_VAL) STORE AS
( TABLESPACE TS_AUD_GEN
ENABLE STORAGE IN ROW
CHUNK 8192
PCTVERSION 10
NOCACHE
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 1000
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
)
LOB (NEW_VAL) STORE AS
( TABLESPACE TS_AUD_GEN
ENABLE STORAGE IN ROW
CHUNK 8192
PCTVERSION 10
NOCACHE
STORAGE (
INITIAL 10M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 1000
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
)
NOCACHE
NOPARALLEL
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
