Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-01692

Unable to extend the LOB segment string.string partition string by string in tablespace string.

Cause

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


Action

One of the following actions may resolve the problem:

  1. Turn ON autoextension for the data files.
  2. Increase MAXSIZE value for autoextensible files.
  3. If the segment is in a SMALLFILE tablespace, add one or more data files.