ORA-01537 錯誤及解決方法
Problem Description
-------------------
You have offline dropped a datafile then try to recreate the datafile (ALTER
DATABASE ADD DATAFILE) with the same name and get error message:
ORA-1537 (datafile already exists) even though you have offline dropped it.
ORA-01537: "cannot add data file '%s' - file already part of database"
Cause: During CREATE or ALTER TABLESPACE, a file being added is already part of the database.
Action: Use a different file name.
ORA-00376: "file %s cannot be read at this time"
Cause: attempting to read from a file that is not readable. Most likely
the file is offline.
Action: Check the state of the file. Bring it online
Solution Description
--------------------
Before proceeding, see Note 111316.1 How to 'DROP' a Datafile from a
Tablespace.
If a tablespace has only one datafile then dropping the tablespace will remove details of the datafile from the data dictionary.
If a tablespace has more than one datafile, then to remove the datafile, the tablespace must be dropped and recreated having exported any data that needs to be retained.
To remove details of the datafile from the Data Dictionary:
1) Export the entire tablespace contents.
2) Drop the tablespace, including contents.
3) Rebuild the tablespace with the datafiles you want it to contain.
4) Import the data back in.
Explanation
-----------
The Data Dictionary still contains information that this datafile
exists. Offline drop of a datafile does not remove it from the Data
Dictionary.
-------------------
You have offline dropped a datafile then try to recreate the datafile (ALTER
DATABASE ADD DATAFILE) with the same name and get error message:
ORA-1537 (datafile already exists) even though you have offline dropped it.
ORA-01537: "cannot add data file '%s' - file already part of database"
Cause: During CREATE or ALTER TABLESPACE, a file being added is already part of the database.
Action: Use a different file name.
ORA-00376: "file %s cannot be read at this time"
Cause: attempting to read from a file that is not readable. Most likely
the file is offline.
Action: Check the state of the file. Bring it online
Solution Description
--------------------
Before proceeding, see Note 111316.1 How to 'DROP' a Datafile from a
Tablespace.
If a tablespace has only one datafile then dropping the tablespace will remove details of the datafile from the data dictionary.
If a tablespace has more than one datafile, then to remove the datafile, the tablespace must be dropped and recreated having exported any data that needs to be retained.
To remove details of the datafile from the Data Dictionary:
1) Export the entire tablespace contents.
2) Drop the tablespace, including contents.
3) Rebuild the tablespace with the datafiles you want it to contain.
4) Import the data back in.
Explanation
-----------
The Data Dictionary still contains information that this datafile
exists. Offline drop of a datafile does not remove it from the Data
Dictionary.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-667864/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-14452錯誤及解決方法
- IMP-00098 錯誤及解決方法
- ORA-00257 錯誤分析及解決方法
- 目標板掛載NFS方法及錯誤解決NFS
- 【ora 錯誤及解決方法】ORA-01652
- Oracle 常見的錯誤問題及解決方法Oracle
- 中科三方——SSL常見錯誤及解決方法
- tensorflow安裝使用過程錯誤及解決方法
- SSL證書7大常見錯誤及解決方法!
- vsftpd 錯誤:530 and 500 錯誤解決方法FTP
- undefined reference to錯誤的解決方法Undefined
- AFNetworkingErrorDomain 錯誤解決方法ErrorAI
- PHP錯誤“Thisfilehasexpired”的解決方法PHP
- dbfread報錯ValueError錯誤解決方法Error
- PHP初學者最常遇到的8個錯誤及解決方法PHP
- SSL證書七大常見錯誤及解決方法
- 【oracle 錯誤及解決】ORA-39139Oracle
- oracle錯誤及解決方式集(轉)Oracle
- HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法HTTPServerError
- 【Oracle】ORA-00054 錯誤解決方法Oracle
- 錯誤Namenodeisinsafemode的解決方法
- Android錯誤解決方法集錦Android
- hadoop日常錯誤解決方法整理Hadoop
- ORA-04098錯誤解決方法
- ORA-25154錯誤解決方法
- npm WARN unmet dependency錯誤解決方法NPM
- Hadoop常見錯誤及解決方案Hadoop
- 開發常見錯誤及解決方案
- PHP編譯錯誤及解決辦法PHP編譯
- sqplus 的 segmentation fault錯誤及解決!Segmentation
- PHP原始碼包編譯安裝錯誤及解決方法彙總PHP原始碼編譯
- standby新增檔案錯誤的解決方法
- MYSQL中 TYPE=MyISAM 錯誤的解決方法MySql
- Mac上搭建chromedriver的錯誤解決方法MacChrome
- 寬頻連線錯誤691解決方法
- ubuntu網路卡啟動錯誤解決方法Ubuntu
- steam磁碟寫入錯誤怎麼解決 steam磁碟寫入錯誤解決方法大全
- 平臺配置及測試錯誤提示及解決方案