我也遇到了。我首先删掉了users表空间的数据文件h:\users01.dbf.然后mount,执行alter database create datafile h:\users01.dbf as f:\users01.dbf 然后出现了ORA-01516 错误。我查了一下
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 (for example, such as resize, autoextend, online/offline, and so on); 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.
请大侠们指点一下!
|