Oracle error
ORA-01691
ORA-01691: unable to extend lob segment %s.%s by %s in tablespace %s
What usually causes it
Same as ORA-01653, for a LOB segment.
What to check first
Add space, and check whether the LOB is growing faster than expected.
Scripts that help
- Tablespace usageUsed and free space in GB against the maximum each tablespace can autoextend to, with its type (permanent, temporary or undo), fullest first.
- Top 20 largest segmentsThe biggest tables, indexes, LOBs and partitions in the database.
- Add space: resize or add a datafileTemplates for the three usual fixes. The resize runs as written; the other two are commented out. Change names and sizes, and uncomment the one you…
Tool
- Tablespace runway and datafilesDays until full, and the statements to add space