CREATE
TEMPORARY
TABLESPACE
statement 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.
To create a tablespace to contain persistent schema objects, use the CREATE
TABLESPACE
statement.
See Also: |
|
Prerequisites
You must have the CREATE
TABLESPACE
system privilege.
Syntax
filespec
: See .
::=
::=
Keywords and Parameters
tablespace
Specify the name of the temporary tablespace.
TEMPFILE
filespec
Specify the tempfiles that make up the tablespace.
Note: Media recovery does not recognize tempfiles. |
|
See Also: |
|
autoextend_clause
The autoextend_clause
lets you enable or disable the automatic extension of the tempfile.
|
Specify |
|
|
Specify |
|
|
Specify the disk space to allocate to the tempfile when more extents are required. |
|
|
The |
|
|
|
|
|
|
|
EXTENT
MANAGEMENT
LOCAL
The EXTENT
MANAGEMENT
clause
lets you specify that the tablespace is locally managed, meaning that
some part of the tablespace is set aside for a bitmap.
|
Specify 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. |
|
|
Specify in bytes the size of the tablespace extents. Use
If you do not specify |
|
See Also: for a discussion of locally managed tablespaces |
|
Example
Temporary Tablespace 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.