Name

CREATE TABLESPACE

Synopsis

CREATE TABLESPACE tablespace_name
DATAFILE 'filename' [SIZE
integer[K | M]] [REUSE]
[autoextend_clause]
   [DEFAULT STORAGE (
      [INITIAL integer[K | M] ]
      [NEXT integer[K | M] ]
      [MINEXTENTS integer]
      [MAXEXTENTS {integer | UNLIMITED} ]
      [PCTINCREASE integer]
      [FREELISTS integer]
      [FREELIST GROUPS integer]
      ) ]
   [ONLINE | OFFLINE ]
   [MINIMUM EXTENT integer[K | M] ]
   [PERMANENT | TEMPORARY]
   [LOGGING | NOLOGGING]

Creates a new tablespace (tablespace_name), optionally specifying default storage characteristics for objects subsequently created in the tablespace.

Keywords

DATAFILE

Specifies the name of the operating system datafile for this tablespace. SIZE is required unless the file already exists, in which case the REUSE keyword must be specified.

autoextend_clause

Specifies whether a given datafile is able to be automatically extended when it runs out of free space. The syntax is shown in the later autoextend_clause section.

DEFAULT STORAGE

Specifies the physical characteristics of the objects subsequently created in this tablespace that do not specify their own storage parameters, as follows:

INITIAL

Specifies the size of the first extent for this tablespace in bytes, kilobytes, or megabytes. If this value is not a multiple of the database blocksize, it will be rounded up to a multiple of the database blocksize.

NEXT

Specifies the size of the next extent in bytes, kilobytes, or megabytes. If this value is not a multiple of the database blocksize, it will be rounded up to a multiple of the database blocksize.

MINEXTENTS

Specifies the number of extents to be allocated when this tablespace is created. The minimum and default value is 1.

MAXEXTENTS

Specifies the maximum number of extents that may be allocated for this tablespace. The default will vary according to the database blocksize. Specify UNLIMITED for unlimited expansion.

PCTINCREASE

Specifies the percentage by which each extent will grow over the previous extent. The default is 50, which means that each extent will be one-and-one-half times larger than the previous extent.

FREELISTS

Specifies the number of free lists contained in each freelist group in this tablespace. The default is 1, and the maximum depends on the database blocksize.

FREELIST GROUPS

Specifies the number of groups of free lists for this tablespace. The default is 1. This parameter should be used only with the Parallel Server option running in parallel mode.

ONLINE

Brings the tablespace online after creation. This is the default.

OFFLINE

Leaves the tablespace offline after creation.

MINIMUM EXTENT

Forces every extent created to be the size specified or a multiple of the size specified. This reduces fragmentation.

PERMANENT

The default value. Allows permanent objects to be created in the tablespace.

TEMPORARY

Specifies that no permanent objects can be stored in the tablespace. Oracle will then find a more efficient access method when using the tablespace for temporary segments.

LOGGING

Specifies the default value of LOGGING for objects created in the tablespace. This default value can be overridden for each object when the object is created.

NOLOGGING

Specifies the default value of NOLOGGING for objects created in the tablespace. This default value can be overridden for each object when the object is created. A value of NOLOGGING indicates that certain operations to the object are not logged to the redo log. This is a performance gain, but leaves the object vulnerable in the event that the tablespace has to be recovered.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.188.96.5