Oracle8i SQL Reference
Release 2 (8.1.6)

A76989-01

Library

Product

Contents

Index

Prev Up Next

SQL Statements (continued), 11 of 11


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.

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index