Name
CREATE TEMPORARY TABLESPACE
Synopsis
CREATE TEMPORARY TABLESPACE <tablespace_name> ... TEMPFILE'filename' [SIZEinteger[K | M] [REUSE]] [Autoextend_clause] [EXTENT MANAGEMENT LOCAL] [UNIFORM] [SIZEinteger[K | M]]
Creates a temporary tablespace, which is used to hold temporary objects (which are retained only for the duration of a session). Like any other tablespace, a temporary tablespace can be dropped with the DROP TABLESPACE command. Temporary tablespaces are not affected by media recovery.
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, you must specify the REUSE keyword.
- 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 the specified size is not a multiple of the database block size, integer will be rounded up to a multiple of it.
- EXTENT MANAGEMENT LOCAL
Specifies that the temporary tablespace be locally managed, meaning that some portion of this tablespace is set aside for a bitmap. New with Oracle9i.
- UNIFORM SIZE
Specifies the size for all extents in this tablespace in bytes, kilobytes (K), or megabytes (M) and indicates that all extents will be equally sized. If integer is omitted, the extent size defaults ...