Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace deleted..............pl help me
At the command line
go to svrmgrl
connect internal
shutdown abort
startup mount
alter database datafile 'path/file' offline drop;
alter database open;
select name,status from v$datafile and note;
drop tablespace xxxxx; Received on Thu Jan 24 2002 - 07:10:31 CST