o**n 发帖数: 14 | 1 the associated datafile was deleted accidentally, | s****d 发帖数: 13 | 2 drop tablespace tab_name
【在 o**n 的大作中提到】 : the associated datafile was deleted accidentally,
| o**n 发帖数: 14 | 3 because the datafile was deleted, can't drop it that way.
【在 s****d 的大作中提到】 : drop tablespace tab_name
| m****a 发帖数: 2 | 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.
|
|