Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter LOB Storage from IN-ROW to Out ROW

3528418Aug 13 2018 — edited Aug 14 2018

Hi Team,

We have table with CLOB column and its storage is In-ROW. We want to alter table to change clob storage type to out-row.

But getting error at time of altering table

--------------------

SQL Error: ORA-22853: invalid LOB storage option specification

22853. 00000 -  "invalid LOB storage option specification"

*Cause:    A LOB storage option was not specified

*Action:   Specify one of CHUNK, PCTVERSION, CACHE, NOCACHE, TABLESPACE,

           STORAGE, INDEX, [A]SYNC or DATA SYNC as part of the LOB storage

           clause.

---------------------

Table CLOB storage is in-ROW.

Want to change clob storage out-row or vice-versa.

Here is syntax which I am trying.

-------------

ALTER TABLE Table_Name_AAA MODIFY LOB(CLOB_COL_NAME) (

  TABLESPACE "TBL_1" DISABLE STORAGE IN ROW CHUNK 16384

);

----------------------

Any idea, Why I am getting above error. Is it due to fact that, Oracle do not allow us to change the settings for ENABLE | DISABLE STORAGE IN ROW.

Is their alternate way to change in-row to out-row storage.

-

Regards

Amit

This post has been answered by odie_63 on Aug 13 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2018
Added on Aug 13 2018
4 comments
2,550 views