Oracle DBA, How To, Error, Cause and Action

ORA-01692: unable to extend lob segment string.string partition stringby string in tablespace string

ORA-01692: unable to extend lob segment string.string partition string by string in tablespace string




Cause: Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.




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