Creating a Tablespace

How To

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:


Related topic:

Working with Tablespaces
User Files

Extending a File