Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
====================================================================
ORA-01516: nonexistent log file, datafile, or tempfile "string" |
Cause: An attempt was made to use ALTER DATABASE to rename a log file, datafile, or tempfile; or to change attributes of a datafile or tempfile (e.g., resize, autoextend, online/offline, etc.); or to re-create a datafile. The attempt failed because the specified file is not known to the database 's control file or is not of a type supported by the request. |
Action: Specify the name or number of an existing file of the correct type, as appropriate. Check the relevant V$ table for a list of possible files. |
alert.log: Thu Jan 22 07:14:33 2009 alter database datafile '/u01/oracle_data/mydb/temp01.dbf' resize 1000M Thu Jan 22 07:14:33 2009 ORA-1516 signalled during: alter database datafile '/u01/oracle_data/mydb/temp01.dbf' resize 1000M ... |
Solution: Use correct syntax: SQL>alter database tempfile '/u01/oracle_data/mydb/temp01.dbf ' resize 100M; |
All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors
Last updated: August 4, 2009 |
