CREATE TABLESPACE
CREATE TABLESPACEtablespace_name
DATAFILE 'filename
' [SIZEinteger
[K | M]] [REUSE] [autoextend_clause
] [DEFAULT STORAGE ( [INITIALinteger
[K | M] ] [NEXTinteger
[K | M] ] [MINEXTENTSinteger
] [MAXEXTENTS {integer
| UNLIMITED} ] [PCTINCREASEinteger
] [FREELISTSinteger
] [FREELIST GROUPSinteger
] ) ] [ONLINE | OFFLINE ] [MINIMUM EXTENTinteger
[K | M] ] [PERMANENT | TEMPORARY] [LOGGING | NOLOGGING]
Creates a new tablespace (tablespace_name), optionally specifying default storage characteristics for objects subsequently created in the tablespace.
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.
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.
Specifies the physical characteristics of the objects subsequently created in this tablespace that do not specify their own storage parameters, as follows:
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.
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.
Specifies the number of extents to be allocated when this tablespace is created. The minimum and default value is 1.
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.
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.
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.
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.
Brings the tablespace online after creation. This is the default.
Leaves the tablespace offline after creation.
Forces every extent created to be the size specified or a multiple of the size specified. This reduces fragmentation.
The default value. Allows permanent objects to be created in the tablespace.
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.
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.
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.
18.188.96.5