A tablespace is a logical group of data files in a database. A database typically contains at
least one tablespace, and usually two or more. Within the database, the tablespace plays a role
similar to that of a folder on the hard drive of a computer.
Some database programs, such as Oracle, automatically create a
tablespace called SYSTEM that contains general information about the structure and contents of the
database. A small database can be entirely contained in the SYSTEM tablespace, but in most cases,
user data is placed in
other tablespaces.
The files in a tablespace usually share a common characteristic. For example, a database for a
wholesale distributor might consist of tablespaces entitled ACCOUNTING, ORDERS, SHIPPING, SERVICE,
and SYSTEM. Each tablespace might contain only one data file, or thousands of files, or anything in
between. Tablespaces can be created, deleted, and merged, just as can the folders on the hard drive of
a computer.
This was last updated in March 2009
Email Alerts
Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy
More News and Tutorials
-
SQL Server Insider e-zine is a quarterly online publication focusing on Microsoft’s enterprise database, SQL Server. Join the editors of SearchSQLServer.com for an in-depth look into the database trends sweeping over Microsoft, including business intelligence, cloud computing and “big data.”
-
SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes.
-
In this Q&A, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.
-
Articles
-
Resources from around the Web
