Thursday, January 22, 2009

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

No comments:

Post a Comment