sqlplus "/as sysdba"
startup mount
--- 非归档模式下
alter database datafile '/home/ora_datafile/test04/hotel_tbl/hotel01.dbf' offline drop;
--- 归档模式下
alter database datafile '/home/ora_datafile/test04/hotel_tbl/hotel01.dbf' offline ;
alter database open;
startup mount
--- 非归档模式下
alter database datafile '/home/ora_datafile/test04/hotel_tbl/hotel01.dbf' offline drop;
--- 归档模式下
alter database datafile '/home/ora_datafile/test04/hotel_tbl/hotel01.dbf' offline ;
alter database open;
解决方案 »
- 在线等!!!!!!!着急!!!!!!
- pl/sql登陆失败问题
- oracle 升级问题,从oracle 8.1.7升级到oracle 9.2出现错误 ora-12560 协议适配器错误
- sql 导入orcal问题
- 求一份toad for load 9.0.1.8的使用教程
- 求教:用varchar(8)还是Number(8)作主键,效率如何?
- PL/SQL中,连Oracle库,有个函数传入参数为数组,如何做测试
- 用vb编程,想把oracle全局数据库的名字读到一个ComboBox中。请给个思路吧,谢谢哦
- Oracle中执行procedure慢!oracle参数该怎么设?
- kettle怎么将文本文件的数据导入到Oracle数据库中
- ★●◆■高分求教!!!大虾都来看看哦,!!!急急,我头都已经冒汗了!!!!
- .NET写的网页,ORACLE数据库,总是报错ORA-01043,求救~~~
alter database archivelog(如果之前你不是归档模式)
alter database datafile 13 offline;
alter database open;
现数据库已打开了,但我在删除表空间时,出错.SQL> drop tablespace HOTEL_TBL including contents;
drop tablespace HOTEL_TBL including contents
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace我使用了:http://www.itpub.net/233575.html
的方法,但还是没有删除掉.
materialized views and/or their indices.
*Action: Drop the materialized views in this tablespace. Also,
find indices belonging to materialized views in this
tablespace and drop then. Then try dropping the tablespace