直接拷贝肯定不行
命令提示符下
svrmgrl
connect internal/oracle
shutdown immediate
startup mount
alter database drop datafile 'c:\oracle\oradata\place.Ora' offline drop;
alter database open;
sql*plus下
connect internal/oracle
drop tablespace place;
命令提示符下
svrmgrl
connect internal/oracle
shutdown immediate
startup mount
alter database drop datafile 'c:\oracle\oradata\place.Ora' offline drop;
alter database open;
sql*plus下
connect internal/oracle
drop tablespace place;
9i我查了一下,可以这样
sqlplus /nolog
connect /as sysdba
shutdown immediate
startup mount
这上面都是正确的,下面这一句出了问题
alter database drop datafile 'c:\oracle\oradata\place.Ora' offline drop;提示是需要LOGFILE关键字
alter database datafile 'c:\oracle\oradata\place.Ora' offline ;
http://community.csdn.net/Expert/topic/4071/4071093.xml?temp=.426922