CREATE TEMPORARY TABLESPACE

Syntax

filespec: See "filespec".

autoextend_clause::=

maxsize_clause::=

Purpose

To create a temporary tablespace, which is an allocation of space in the database that can contain schema objects for the duration of a session.

Prerequisites

You must have the CREATE TABLESPACE system privilege.

Keywords and Parameters

tablespace	is the name of the temporary tablespace.
TEMPFILE filespec	specifies the tempfiles that make up the tablespace. See "filespec".
	Note: Media recovery does not recognize tempfiles.
autoextend_clause	enables or disables the automatic extension of the tempfile.
	OFF	disables autoextend if it is turned on. NEXT and MAXSIZE are set to zero. Values for NEXT and MAXSIZE must be respecified in further ALTER TABLESPACE AUTOEXTEND statements.
	ON	enables autoextend.
	NEXT	specifies the disk space to allocate to the tempfile when more extents are required.
	maxsize_clause	specifies the maximum disk space allowed for allocation to the tempfile.
	integer	specifies in bytes the maximum disk space allowed for allocation to the tempfile. Use K or M to specify this space in kilobytes or megabytes.
	UNLIMITED	sets no limit on allocating disk space to the tempfile.
EXTENT MANAGEMENT LOCAL	specifies that the tablespace is locally managed, meaning that some part of the tablespace is set aside for a bitmap. For a discussion of locally managed tablespaces, see Oracle8i Concepts.
	UNIFORM	determines the size of the extents of the temporary tablespace in bytes. All extents of temporary tablespaces are the same size (uniform). If you do not specify this clause, Oracle uses uniform extents of 1M.
	SIZE	specifies in bytes the size of the tablespace extents. Use K or M to specify the size in kilobytes or megabytes. If you do not specify SIZE, Oracle uses the default extent size of 1M.

Example

This statement creates a temporary tablespace in which each extent is 16M.

CREATE TEMPORARY TABLESPACE tbs_1 TEMPFILE 'file_1.f'
   EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;

If we assume the default database block size of 2K, and that each bit in the map represents one extent, then each bit maps 8,000 blocks.