This content has been marked as final. Show 2 replies
Find out which tablespace the datafile is in, a SYSTEM connection in sqlplus and drop the tablespace:
to delete the tablespace ... the EXPDB.DBF file
That's it. If there are any sessions with pending DML or DDL on objects stored in that tablespace, the drop command will not succeed.
select t.name, f.name from v$tablespace t, v$datafile f where t.ts# = f.ts# and f.name like '%EXPDB%' ... <tblspace> <[drive:]/path/filename> drop tablespace <tblspace> including contents and datafiles;