ORA-01516 nonexistent log file, datafile or tempfile 'string'
Cause: An attempt was made to use ALTER DATABASE to either rename a log file or datafile, or change attributes of a datafile or temporary file. The attempt failed because the specified file is not known to the database's control file or is not a type supported for the request不存在的数据文件
Cause: An attempt was made to use ALTER DATABASE to either rename a log file or datafile, or change attributes of a datafile or temporary file. The attempt failed because the specified file is not known to the database's control file or is not a type supported for the request不存在的数据文件
解决方案 »
- oracle 删除表问题
- oracle语句问题
- SQL中使用distinct去除重复列遇到的问题
- ora-04031 无法分配4096字节的共享内存
- sql语句优化问题,现在这个sql 运行速度比较慢,怎么优化一下? 谢谢!
- 我想启动oracle进程,但不想启动实例,怎么办啊?????????
- 触发器中是否可以使用动态循环结构插入修改数据??实现如下功能
- 急!!!!请问ORACLE数据库服务器改IP需要做什么处理吗?(在线等候)
- king用户创建了哪些表呀?owner为king的表有哪些呀?
- 求助一个函数实现方法
- plsql中如何删除和移动指定文件。
- Oracle 8.0.3如何安装的问题!!
SQL> select name from v$datafile;NAME
----------------------------------------------------------------------------------------------------
E:\ORACLE\ORADATA\WOWS\SYSTEM01.DBF
E:\ORACLE\ORADATA\WOWS\RBS01.DBF
E:\ORACLE\ORADATA\WOWS\USERS01.DBF
E:\ORACLE\ORADATA\WOWS\TEMP01.DBF
D:\ORACLE\ORADATA\WOWS\TOOLS01.DBF
E:\ORACLE\ORADATA\WOWS\INDX01.DBF
D:\ORACLE\ORADATA\WOWS\DR01.DBF
E:\ORACLE\ORADATA\WOWS\OEM_REPOSITORY.ORA
首先shutdown
然后startup mount
然后使该文件offline(失败)(alter database datafile 'E\DDD.DBF' OFFLINE
再次
alter database open
最后删除该表空间
alter tablespace test
然后startup mount
然后使该文件offline(失败)(alter database datafile 'E\DDD.DBF' OFFLINE
再次
alter database open
最后删除该表空间
alter tablespace test"
是在 noarchivelog 的操作。
alter database noarchivelog
*
ORA-01157: ????/?????? 10 - ??? DBWR ????
ORA-01110: ???? 10?'E:/DDD.DBF'
SVRMGR>
DROP TABLESPACE <TSNAME> INCLUDING CONTENTS;
alter database create datafile oldfile as newfile
recover datafile newfile
建立一个新的数据文件
无法测试了