Oracle Tablespaces DDL


CREATE Tablespace

This command allows the creation of tablespaces and one or more initial datafiles. Tablespaces can contain multiple datafiles.

CREATE TEMPORARY Tablespace

Creates a locally managed temporary tablespace. The uniform size parameter should be set to an exact multiple of the SORT_AREA_SIZE parameter size for in-memory sorting in the SGA.

CREATE TEMPORARY TABLESPACE tablespace
	TEMPFILE file specification
	[autoextend clause]
		[AUTOEXTEND OFF | AUTOEXTEND ON [ NEXT n [K | M] ] [MAXSIZE UNLIMITED | MAXSIZE n [K | M] ] ]
	[EXTENT MANAGEMENT LOCAL]
	[UNIFORM [SIZE n [K | M] ]

ALTER Tablespace

Tablespaces can be altered to add datafiles, change online status, recoverability, backup status and tablespace default storage characteristics.

DROP Tablespace

A tablespace which contains active segments cannot be dropped.