Creating a Tablespace |
Smaller tables that contain data of a similar nature can be grouped in a single tablespace, but very large tables should be placed in their own tablespaces. A regular tablespace has a fixed size and contains one or more data files. If the physical file of a regular tablespace is too small to hold all the data you wish to store in it, you must enlarge it manually. An autoextend tablespace is a tablespace that will automatically grow as needed. Consider the following when creating a tablespace:
The logical name must be a unique name.
There are two types of files available: DATA or BLOB.
In the case of a data file in a tablespace, the size is represented as the number of pages. In the case of a BLOB file, the size is represented as the number of frames.
A BLOB file cannot be the only file in a single tablespace. There should be at least one data file in a tablespace. Tablespace creation will fail if no data file is included..
Related topic: