ORA-01516

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

Last updated: August 4, 2009