Oracle DBA, How To, Error, Cause and Action

ORA-03238: unable to extend LOB segment string.string subpartitionstring by string in tablespace string

ORA-03238: unable to extend LOB segment string.string subpartition string by string in tablespace string




Cause: An attempt was made to allocate an extent for LOB subpartition segment in tablespace, but the extent could not be allocated because there is not enough space in the tablespace indicated.




Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.