Using Multiple Tablespaces (46)

tsinglee發表於2007-09-28
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@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-973524/,如需轉載,請註明出處,否則將追究法律責任。

相關文章