My Oracle Support Banner

Primary Note: Overview of Oracle Tablespace Management (Doc ID 1493350.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and environment data used
represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered
with an Oracle database product or other training material. Any similarity to actual environments,
actual persons, living or dead, is purely coincidental and not intended in any manner.



Purpose

This Notes describes the various aspects of tablespace management and is to instruct engineers and customers how to better diagnose Tablespace related issues / questions.

Scope

 Guidelines for Managing Oracle Tablespaces

Details

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
Scope
Details
 Overview of Tablespaces
 Using Multiple Tablespaces
 Assigning Tablespace Quotas to Users
 Creating Tablespaces
 Tablespace types
 Locally Managed Tablespaces
 Bigfile Tablespaces
 Compressed Tablespaces
 Encrypted Tablespaces
 Temporary Tablespaces
 Specifying Nonstandard Block Sizes for Tablespaces
 Controlling the Writing of Redo Records
 Altering Tablespace Availability
 Using Read-Only Tablespaces
 Making a Tablespace Read/Write
 Creating a Read-Only Tablespace on a WORM Device
 Delaying the Opening of Datafiles in Read-Only Tablespaces 
 Altering and Maintaining Tablespaces
 Increasing the Size of a Tablespace
 Altering a Locally Managed Tablespace
 Altering a Bigfile Tablespace
 Altering a Locally Managed Temporary Tablespace
 Shrinking a Locally Managed Temporary Tablespace
 Renaming Tablespaces
 Dropping Tablespaces
 Managing the SYSAUX Tablespace
 Monitoring Occupants of the SYSAUX Tablespace
 Moving Occupants Out Of or Into the SYSAUX Tablespace
 Diagnosing and Repairing Locally Managed Tablespace Problems
 Migrating from a Dictionary Managed to a Locally Managed Tablespace
 Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
 Transporting Tablespaces Between Databases
 Tablespace Data Dictionary Views
 Troubleshooting
 References
References

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