CREATE TEMPORARY TABLESPACE

Create a temporary tablespace.

Syntax:

   CREATE TEMPORARY TABLESPACE tablespace_name
      TEMPFILE Tempfile_Options 
         [EXTENT MANAGEMENT LOCAL] 
            [UNIFORM [SIZE int K | M] ];

Tempfile_Options:
    'filespec' [AUTOEXTEND OFF]
    'filespec' [AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]]

The Autoextend Maxsize clause will default to UNLIMITED if no value is specified.

To create a locally managed tablespace specify 'EXTENT MANAGEMENT LOCAL'.

All extents of temporary tablespaces are the same size - if UNIFORM is not defined it will default to 1 MB.

There are two kinds of fool. One says, "This is old, and therefore good." And one says, "This is new, and therefore better" - John Brunner, The Shockwave Rider

Related Commands:

ALTER TABLESPACE
CREATE TABLESPACE
DROP TABLESPACE

Related Views:

 DBA_DATA_FILES 
 DBA_TABLESPACES                           USER_TABLESPACES
 DBA_TEMP_FILES 
 DBA_TS_QUOTAS                             USER_TS_QUOTAS 

 V$TEMPFILE
 V$TEMPORARY_LOBS
 V$TEMPSTAT      




Back to the Top

Simon Sheppard
SS64.com