ORA-01116: error in opening database file 14
SQL>drop tablespace test including contents
ERROR at line 1:
ORA-01116: error in opening database file 14
ORA-01110: data file 14: '/oracle8/oradata/dtgdb/test.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3[@more@]
ERROR at line 1:
ORA-01116: error in opening database file 14
ORA-01110: data file 14: '/oracle8/oradata/dtgdb/test.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3[@more@]
由於在Linux下不小心誤刪除了一個資料檔案,結果刪除包含該資料檔案的表空間的時候報錯!但是如果在windows下面的話,正在使用的資料檔案是不能刪除的!
SQL>drop tablespace test including contents
ERROR at line 1:
ORA-01116: error in opening database file 14
ORA-01110: data file 14: '/oracle8/oradata/dtgdb/test.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
SQL>alter database datafile '/oracle8/oradata/dtgdb/test.dbf' offline drop;
datafile dropped;
SQL>drop tablespace test including contents;
Tablespace dropped.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8494287/viewspace-1444347/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- OGG-01028 Opening file errorError
- ERROR OGG-00446 Missing filename opening checkpoint file.Error
- 3.2.2 Opening a Closed DatabaseDatabase
- ERROR 23 (HY000) at line 29963: Out of resources when opening fileError996
- 關於WAS當中FFDC報告error in opening zip file剖析及解決Error
- Oracle Database on NFS : unable to lock file - already in use" ErrorOracleDatabaseNFSError
- TNS-04414 file error 錯誤解決Error
- 3.2.3 Opening a Database in Read-Only ModeDatabase
- 3.1.5.2 Starting an Instance, and Mounting and Opening a DatabaseDatabase
- reduce the database log fileDatabase
- OGG-01453 Database login information not specified in parameter fileDatabaseORM
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- ORA-01114: IO error writing block to file (block #)ErrorBloC
- Opening a Database(資料庫可以被正常開啟的前提)Database資料庫
- Error 15: File not found for RedhatErrorRedhat
- HPUX Error 23 File table overflowUXError
- 詭異的OGG-01004 Database error 1403 no data foundDatabaseError
- Specifying the Database Time Zone File (81)Database
- Solaris syntax error: unexpected end of fileError
- RMAN-05517: temporary file conflicts with file used by target database(zt)Database
- Unload data to a flat file from Oracle databaseOracleDatabase
- database error 12154 at CONDatabaseError
- java.io.IOException: Error opening job jar: hadoop-0.20.2-examples.jarJavaExceptionErrorJARHadoop
- "Failed to create empty document" error message appears when opening the BrightStor ARCserve BackupAIErrorAPP
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- Oracle Database 11gR2引入的DBFS(Database File System)OracleDatabase
- fatal error: openssl/sha.h: No such file or directoryError
- fatal error: sys/cdefs.h: No such file or directoryError
- recover database using backup control fileDatabase
- Migrate database to Exadata with DBMS_FILE_TRANSFERDatabase
- Database Clone by rebuilding control file.DatabaseRebuild
- Tasks of a Database Administrator : Back Up the Fully Functional Database (14)DatabaseFunction
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- fatal error: libmemcached/memcached.h: No such file or directoryErrorIBM
- ScalaSigParserError: Unexpected error: Not a valid class fileError
- line 10:syntax error: unexpected end of fileError
- R安裝package報ERROR: a 'NAMESPACE' file is requiredPackageErrornamespaceUI