CREATE TEMPORARY TABLESPACE 
CREATE TEMPORARY TABLESPACE 
   TEMPFILE 'filename` [SIZE integer [K | M] [REUSE]]
   [Autoextend_clause]
   [EXTENT MANAGEMENT LOCAL]
   [UNIFORM] [SIZE integer [K | M]]

Creates a temporary tablespace, which is used to hold temporary objects (retained only for the duration of a session).

Like any other tablespace, a temporary tablespace can be dropped with the DROP TABLESPACE command.

Keywords

TEMPFILE

Specifies the name of the operating system datafile for this temporary tablespace.

SIZE

Specifies the size of the file in bytes, kilobytes (K), or megabytes (M). SIZE is required unless the file already exists. If the file already exists, the REUSE keyword must be specified.

REUSE

Specifies that the operating system file must already exist and be reused for this temporary tablespace.

INITIAL

Specifies the size of the first extent for a new object in bytes, kilobytes (K), or megabytes (M). If not a multiple of the database block size, the size will be rounded up to a multiple of it.

Autoextend_clause

Specifies whether autoextend will be in effect for the datafile. See Chapter 4 for more information.

EXTENT MANAGEMENT LOCAL

Specifies that the temporary tablespace be locally managed, meaning that some portion of this tablespace is set aside for a bitmap.

UNIFORM SIZE

Specifies the size for all extents in this tablespace in bytes, kilobytes (K) or megabytes (M), and ...

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial