Oracle error
ORA-01654
ORA-01654: unable to extend index %s.%s by %s in tablespace %s
What usually causes it
Same as ORA-01653, for an index.
What to check first
Add space to the tablespace. Check for an index that grew unexpectedly.
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.
- Datafiles with size and autoextend limitsEvery datafile, its current size, whether it can grow, and how far. Files with AUTOEXTEND NO in a busy tablespace are the ones that page you at night.
- 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