關於tablespace在read only狀態下的DML ,DDL操作--Read-Only Tablespaces
Read-Only Tablespaces
You can drop items, such as tables or indexes, from a read-only tablespace, but you cannot create or alter objects in the tablespace. You can execute statements that update the file description in the data dictionary, such as ALTER TABLE...ADD or ALTER TABLE...MODIFY, but you will not be able to utilize the new description until the tablespace is made read-write.
You can drop items, such as tables or indexes, from a read-only tablespace, but you cannot create or alter objects in the tablespace. You can execute statements that update the file description in the data dictionary, such as ALTER TABLE...ADD or ALTER TABLE...MODIFY, but you will not be able to utilize the new description until the tablespace is made read-write.
一個使用者表空間test置為read only模式之後,DML操作自然是不行的,不過如果是純粹的DDL操作,並且不涉及到使用者表空間下的表中的資料(也就是僅僅更改資料字典--資料字典存在system表空間下,system是online的),那麼是可以的。
但是如果設計到這個表空間的table的資料,就不能更改,必須等到這個test表空間置為讀寫狀態才能執行。
比如: test 表空間為read only , 其中有一個table 為 test1_table , 表中如果沒有資料,那麼對錶欄位修改,加入,刪除欄位是允許的,不過如果其中已經有資料了,那麼加入,刪除就涉及到了這個tablespace( 原來沒有資料,只是涉及到資料字典,而資料字典表空間是system ) .
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-85136/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 啟動dataguard備庫到read-only狀態
- CSS :read-only 選擇器CSS
- read only tablespace backup restoreREST
- 3.2.3 Opening a Database in Read-Only ModeDatabase
- Oracle Isolation Levels : Read-only (317)Oracle
- linux下操作檔案出現 Read-only file systemLinux
- DDL、DML、DCL、DQL相關操作
- Open a Database in Read-Only Mode (301)Database
- 作業系統報:read-only file system作業系統
- idea怎麼修改檔案的file is read-onlyIdea
- 透過Buffer cache瞭解data block在DML操作下的狀態演變BloC
- Why NHibernate updates DB on commit of read-only transactionMIT
- Read-Only Tables in Oracle Database 11g Release 1OracleDatabase
- Oracle 11g 新特性:只讀表(Read-only)Oracle
- remount of /system failed: Read-only file system原因及解決REMAI
- DML操作 DDL觸發器觸發器
- MySQL的DDL和DML操作語法MySql
- 005-blocked by: [FORBIDDEN/12/index read-only / allow delete (api)]BloCORBIndexdeleteAPI
- Linux-x86_64 Error: 30: Read-only file systemLinuxError
- Mysql 基礎操作 DDL DML DCLMySql
- Error:/etc/fstab:Read-only file system錯誤的解決辦法Error
- 表空間read only和online的狀態轉換
- DML, DDL操作的自動提交問題
- oracle實驗記錄 (恢復read only tablespace(1))Oracle
- oracle實驗記錄 (恢復read only tablespace(2))Oracle
- /dev/null Read-only file system 系統無法啟動薦devNull
- 重建控制檔案與 datafile offline,tablespace read only
- 【TABLE】11g中只讀表(Read-only Table)技術特性
- 配置支援DML和DDL操作同步的GoldenGateGo
- Oracle DBLINK 抽數以及DDL、DML操作Oracle
- 使用Logminer工具分析DML和DDL操作
- 【報錯】elasticsearch 報錯blocked by: [FORBIDDEN/12/index read-only / allow delete (api)]ElasticsearchBloCORBIndexdeleteAPI
- When you issue "ALTER TABLESPACE xxx READ ONLY",what will oracle do?Oracle
- DDL,DML操作對結果快取的影響快取
- MySQL案例04:Cause: java.sql.SQLException: Could not retrieve transaction read-only status from serverMySqlJavaExceptionServer
- macOS 無法sudo建立資料夾返回Read-only file system問題解決Mac
- oracle ocp 19c考題,科目082考試題(21)-read-only tableOracle
- iOS狀態列相關操作iOS