To alter the maxextents of a LOB, try the next statement:
ALTER TABLE
MOVE LOB (
(STORAGE (MAXEXTENTS UNLIMITED));
ALTER TABLE. MOVE LOB ( ) STORE AS (STORAGE (MAXEXTENTS UNLIMITED));
I tried using the following statement, but got only EM’s:
ALTER TABLE. MODIFY LOB ( ) (STORAGE (MAXEXTENTS UNLIMITED))
The first statement worked, don’t know why the second didn’t…
*edit*: Don’t forget to rebuild the indexes !