Oracle error
ORA-01688
ORA-01688: unable to extend table %s.%s partition %s by %s in tablespace %s
What usually causes it
Same as ORA-01653, for a table partition.
What to check first
Add space to the partition's tablespace.
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.
- 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