alter database datafile offline and alter database tablespace ...offline
You cannot do 'alter database datafile ... offline' if you are in noarchivelog (but tablespace offline works)
You cannot do 'alter tablespace ... offline' if database is read-only (but datafile offline works)[@more@]
You cannot do 'alter tablespace ... offline' if database is read-only (but datafile offline works)[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9907339/viewspace-1038344/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- alter database datafile offline drop 與 alter tablespace drop datafile 區別Database
- ALTER DATABASE DATAFILE OFFLINEDatabase
- alter database datafile 4 offline drop;Database
- ALTER DATABASE 與 ALTER TABLESPACE OFFLINE的區別Database
- alter database offline 與 alter database offline drop效果比對Database
- alter database datafile .... offline drop的問題Database
- alter database datafile offline drop相關問題Database
- datafile offline 與alter tablespace offline 的區別
- alter database create datafileDatabase
- alter database create datafile '' as ''Database
- alter database drop datafile 與 drop tablespace file 的區別Database
- [20111227]Alter database datafile offline drop後的恢復.txtDatabase
- alter database ... create datafile的原理及用途Database
- 恢復一則 alter database create datafile '' as ''Database
- tablespace offline與datafile offline 區別
- Alter database datafile resize ORA-03297 原因解析Database
- UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statementDatabase
- 在alter tablespace_datafile begin backup_offline_oracle block之fileq和ckptq變化OracleBloC
- tablespace offline 和datafile offline的區別
- VMS: ALTER TABLESPACE/DATABASE TO RENAME FILES on VMS [ID 9560.1]Database
- alter database in OracleDatabaseOracle
- oracle裡tablespace offline和datafile offline的區別Oracle
- alter database和alter system和alter session的區別DatabaseSession
- alter database open resetlogs;Database
- alter database disable thread 2Databasethread
- ALTER DATABASE RESETLOGS 的作用Database
- DATA GUARD 中alter database 命令Database
- 忍不住問下alter system 和alter database的區別Database
- Oracle DBA命令參考——alter databaseOracleDatabase
- 重建控制檔案與 datafile offline,tablespace read only
- ALTER DATABASE CLEAR UNARCHIVED LOGFILE的使用DatabaseHive
- alter system dump datafile headerHeader
- alter database backup controlfile to trace的問題Database
- 在alter database mount時的一點收穫Database
- alter database backup controlfile to trace的含義Database
- Display Storage Map for Database | Tablespace | Datafile Storage_1377458.1Database
- 重建控制檔案--alter database backup controlfile to traceDatabase
- 冷備手工完全恢復（recover database，recover tablespace，recover datafile）Database