How to add storage parameters after creation of table for LOB column [message #334383] |
Wed, 16 July 2008 06:13  |
grpatwari
Messages: 288 Registered: June 2008 Location: Hyderabad
|
Senior Member |
|
|
Hi,
I created table with clob column but i have not added the storage parameters. I want to alter the table for clob column with the following values.
LOB (CERTIFICATE) STORE AS (PCTVERSION 10 CHUNK 2K CACHE).
Please suggest.
CREATE TABLE TEST
(
TEST_ID VARCHAR2(32) PRIMARY KEY,
CERTIFICATE CLOB,
)
STORAGE
(
INITIAL 50M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS 10
PCTINCREASE 25
);
|
|
|
|
|
|
|