Oracle error
ORA-01653
ORA-01653: unable to extend table %s.%s by %s in tablespace %s
What usually causes it
The tablespace has no free extent large enough and its datafiles can't autoextend further.
What to check first
Resize a datafile, raise its autoextend limit, or add a datafile. Check what grew before you add space.
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…
- Top 20 largest segmentsThe biggest tables, indexes, LOBs and partitions in the database.
Tool
- Tablespace runway and datafilesDays until full, and the statements to add space