Home » SQL & PL/SQL » SQL & PL/SQL » How to add storage parameters after creation of table for LOB column (Oracle 10g)
How to add storage parameters after creation of table for LOB column [message #334383] Wed, 16 July 2008 06:13 Go to next message
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
);
Re: How to add storage parameters after creation of table for LOB column [message #334388 is a reply to message #334383] Wed, 16 July 2008 06:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SQL> alter table test modify LOB (CERTIFICATE) (PCTVERSION 10 CACHE);

Table altered.

As far I know, you can't modify chunk after lob creation.

Regards
Michel
Re: How to add storage parameters after creation of table for LOB column [message #334509 is a reply to message #334388] Wed, 16 July 2008 21:58 Go to previous messageGo to next message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
Is there any solution for modifying the Chunk storage parameter.

Please suggest.
Re: How to add storage parameters after creation of table for LOB column [message #334519 is a reply to message #334509] Wed, 16 July 2008 23:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Recreate the LOB: add a new column, move the value, drop the previous column.

Regards
Michel
Re: How to add storage parameters after creation of table for LOB column [message #335115 is a reply to message #334519] Mon, 21 July 2008 01:18 Go to previous message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
Thank you very much Michel.
Previous Topic: Execute Immediate / Forall
Next Topic: Convert Number to hours or minutes
Goto Forum:
  


Current Time: Sun Feb 09 09:51:49 CST 2025