一、基本概念：

           表空间数据库逻辑结构的一部分。物理上讲，数据库数据时存放在数据文件里；从逻辑上说，数据库数据存放在表空间（Tablespace）里。表空间由一个或多个数据文件组成。

数据库的逻辑结构：

二、官方文档写的很详细：

■ Guidelines for Managing Tablespaces

■ Creating Tablespaces

■ Specifying Nonstandard Block Sizes for Tablespaces

■ Controlling the Writing of Redo Records

■ Altering Tablespace Availability

■ Using Read-Only Tablespaces

■ Renaming Tablespaces

■ Dropping Tablespaces

■ Managing the SYSAUX Tablespace

■ Diagnosing and Repairing Locally Managed Tablespace Problems

■ Migrating the SYSTEM Tablespace to a Locally Managed Tablespace

■ Transporting Tablespaces Between Databases

■ Viewing Tablespace Information

1）Guidelines for Managing Tablespaces

表空间的管理原则：1、使用多个表空间。2、对用户分配配额

1）  Using Multiple Tablespaces

Using multiple tablespaces allows you more flexibility in performing database

operations. When a database has multiple tablespaces, you can:

■ Separate user data from data dictionary data to reduce I/O contention.

            独立用户数据，从数据字典方面来减少i/o

■ Separate data of one application from the data of another to prevent multiple

applications from being affected if a tablespace must be taken offline.

其实还是独立用户数据，一个应用程序使用多个表空间，其中一个表空间脱机，不影响其他数据。

■ Store different the datafiles of different tablespaces on different disk drives to

reduce I/O contention.

           存储数据文件到不同的磁盘，还是减少i/o

■ Take individual tablespaces offline while others remain online, providing better

overall availability.

一个表空间脱机，其他表空间在线，保持数据库的高可用性

■ Optimizing tablespace use by reserving a tablespace for a particular type of

database use, such as high update activity, read-only activity, or temporary

segment storage.