WHY TABLESPACES?
Tablespaces perform a number of key functions in an Oracle database, but the concept of a tablespace is not common
to all relational databases. For instance, the Microsoft SQL Server database doesn’t use this concept at all.
Here’s a brief list of the benefits of using tablespaces:
Tablespaces make it easier to allocate space quotas to various users in the database.
Tablespaces enable you to perform partial backups and recoveries based on the tablespace as a unit.
Because a large object like a data warehouse partitioned table can be spread over several tablespaces, you can increase performance by spanning the tablespace over several disks and controllers.
You can take a tablespace offline without having to bring down the entire database.
Tablespaces are an easy way to allocate database space.
You can import or export specific application data by using the import and export utilities at the tablespace level
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/37724/viewspace-152587/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Jim Gray：数据管理历史
下一篇：
Oracle中的checkpoint进程
请登录后发表评论
登录
全部评论
