I have the following ALTER TABLE statement (executed on 11gr2):
alter table xyz modify default attributes (
lob (col_x) store as (
tablespace lob_data
enable storage in row
storage (initial 4k)
)
lob (col_y) store as (
tablespace lob_data
enable storage in row
storage (initial 4k)
)
)
/
I get the following exception however:
ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations.
I do not understand how I am combining altering lob storage with "other" operations.
Question is, how can default lob storage be modified?