WHY TABLESPACES?

最新推荐文章于 2025-12-04 15:25:15 发布

转载最新推荐文章于 2025-12-04 15:25:15 发布 · 64 阅读

文章标签：

#数据库

本文介绍了Oracle数据库中使用表空间的优点，包括易于分配空间配额、支持部分备份与恢复、提高大型对象性能、允许离线操作而无需关闭整个数据库等。此外还提到了通过表空间级导入导出特定应用数据的方法。

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博客 ” ，链接：http://blog.itpub.net/37724/viewspace-152587/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/37724/viewspace-152587/