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