A very small database may need only the SYSTEM tablespace; however, Oracle
recommends that you create at least one additional tablespace to store user data
separate from data dictionary information. This gives you more flexibility in
various
database administration operations and reduces contention among dictionary
objects
and schema objects for the same datafiles.
1. 一个数据库最少需要system表空间
2. 使用多个表空间 ， 你可以将用户数据与数据字段分开
，减少同一数据文件在系统和用户对象之间的竞争[@more@]
recommends that you create at least one additional tablespace to store user data
separate from data dictionary information. This gives you more flexibility in
various
database administration operations and reduces contention among dictionary
objects
and schema objects for the same datafiles.
1. 一个数据库最少需要system表空间
2. 使用多个表空间 ， 你可以将用户数据与数据字段分开
，减少同一数据文件在系统和用户对象之间的竞争[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-973524/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002864
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
