There are two types of table spaces that can exist in a database: system-managed space (SMS) and database-managed space (DMS).
An SMS table space is managed by the operating system, which stores the database data into a space that is assigned when a table space is created. The table space definition includes a list of one or more of the directory paths where this data is stored.
The file system manages the allocation and management of media storage.
SMS and DMS table spaces can coexist in the same database.
[ Top of Page | Table of Contents | Glossary | Index ]