question: how to drop a tablespace# Database - 数据库
o*n
1 楼
the associated datafile was deleted accidentally,
s*d
2 楼
drop tablespace tab_name
【在 o**n 的大作中提到】
: the associated datafile was deleted accidentally,
【在 o**n 的大作中提到】
: the associated datafile was deleted accidentally,
o*n
3 楼
because the datafile was deleted, can't drop it that way.
【在 s****d 的大作中提到】
: drop tablespace tab_name
【在 s****d 的大作中提到】
: drop tablespace tab_name
m*a
4 楼
try this:
select tablespace_name,file_name,status from dba_data_files;
if the datafiles you deleted still shows "AVILABLE"
you need to do this for each of those files:
alter database data file 'filename' offline;
then you can do
drop tablespace tablespacename.
【在 o**n 的大作中提到】
: because the datafile was deleted, can't drop it that way.
select tablespace_name,file_name,status from dba_data_files;
if the datafiles you deleted still shows "AVILABLE"
you need to do this for each of those files:
alter database data file 'filename' offline;
then you can do
drop tablespace tablespacename.
【在 o**n 的大作中提到】
: because the datafile was deleted, can't drop it that way.
相关阅读
生物大叔转业记想report SQL Server 2008的一个不足之处--output more than 1 million rows into EXCEL有人用as/400,写ibm的cl,rpg程序吗？有人在准备MSSQL 70-433 吗？刚装的 SQL server 2012 express 咋打不开呀?报Offer+上经验（F, Y, E, M, F, ...) (转载)文科出身在top it工作读information sysyem 前景Uncommited transaction 能写到 log嘛？ sql server第一贴：有木免费的SSMS svn plugin?谢！redgate太贵老泪纵横【隆重推出】北美华人SQL Server User Group (CINASSUG)MS SQL Server 的 bulk insert permission有没有人对这些SQL SERVER 培训感兴趣啊有人试过用 Oracle Standby Read Only database 的 Backup 来Restore？请问：关于做大数据处理和mongoDB的工作，前景如何找SQL developer的工作应该考什么证书啊超龄大妈要改行，寻求建议，谢谢！装不上SQL ２００８Need help for imdbpy新人问，最近还有啥课上吗？