Using Multiple Tablespaces (46)
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部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-973524/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- use multiple tablespaces to perform the following tasks (47)ORM
- How to Move Tablespaces Across Platforms Using Transportable Tablespaces With RMAN [ID 371556.1]ROSPlatform
- Using Multiple Variables with the Same Name
- How to Move a Database Using Transportable Tablespaces (文件 ID 1493809.1)Database
- Oracle Encrypted TablespacesOracle
- Overview of Tablespaces (38)View
- Oracle Transporting TablespacesOracle
- oracle bigfile tablespacesOracle
- Transport of Tablespaces Between Databases (59)Database
- Multiple Regression
- 46
- [MetalKit]46-Introduction to compute using Metal 用 Metal 進行計算的簡介
- 2.5 Overview of Tablespaces and Database Files in a CDBViewDatabase
- Temporary tablespaces in RAC ? Oracle databas...Oracle
- Backing Up Individual Tablespaces with RMAN
- Transporting Tablespaces with Self-ContainedAI
- Step 8: Create Additional Tablespaces (66)
- JavaScript select multipleJavaScript
- Small Multiple(最短路)
- DataGridView with multiple tableView
- Multiple Buffer Pools (83)
- Multiple Block Sizes (53)BloC
- vue46Vue
- ORACLE撤銷表空間(Undo Tablespaces)Oracle
- DELETE from DBA_TABLESPACES IN 10Gdelete
- 2.3.6.2 Synchronization of Multiple ApplicationsAPP
- Multiple Books多賬薄
- Multiple Render Targets in OpenGL with Cg
- MySql multiple servers on linuxMySqlServerLinux
- ssis multiple table to one file
- maven Multiple sourceDirectory外掛Maven
- LLM multiple modal applicationsAPP
- FastAPI(46)- JSONResponseASTAPIJSON
- android-Maintaining Multiple APKs,Creating Multiple APKs for Different API LevelsAndroidAIAPKAPI
- Transportable Tablespaces (TTS) for Oracle Database [ID 1461278.2]TTSOracleDatabase
- Logstash Multiple Pipelines
- kubernetes traefik multiple namespacesnamespace
- How to modify multiple items in the SAP menu