My Oracle Support Banner

10g: Temporary Tablespaces Group (Doc ID 245645.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.

Purpose

 

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 built-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.

This document explains why and how to create groups of temporary tablespaces.

Grouping temporary tablespaces within a single group enables a user to consume temporary space from multiple tablespaces.

 This document is intended for database administrators who want to review general information about the new feature in 10g that allows to group temporary tablespace within groups.

Questions and Answers

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
Questions and Answers
  
 What is Temporary tablespace group
 
Examples
 ORA-10921 Error

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