Primary Note: Overview of Oracle Tablespace Management
(Doc ID 1493350.1)
Last updated on DECEMBER 11, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.0 and laterInformation 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 |