My Oracle Support Banner

Primary Note: Troubleshooting Oracle Tablespace Management (Doc ID 1522807.1)

Last updated on AUGUST 23, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document helps to resolve Common Issues Involving Oracle Tablespace Management i.e ORA-01650 / ORA-01652 / ORA-01653 / ORA-01654 and ORA-01658 and also provides links to Useful Scripts for Tablespace Management.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Concepts
 Common Issues Involving Oracle Tablespace Management
 SYSTEM Tablespace Issues
 SYSAUX Tablespace Issues
 Temporary Tablespace Issues
 UNDO Tablespace Issues
 Helpful Articles on UNDO Tablespaces
 Tablespace Monitoring Issues
 "unable to extend ... by %s in tablespace <name>" ( incl. ORA-01650 / ORA-01652 / ORA-01653 / ORA-01654 and ORA-01658 ) Issues
 Other ORA- Errors/Known Issues Involving Tablespaces
 Drop Tablespace / Datafile Issues
 Transportable Tablespace Issues
 Helpful Articles on Tablespaces (How to / Scripts)
 How to Articles
 Useful Scripts for Tablespaces
 Further Diagnostics
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.