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;
If the previous install was unsuccessful, then you should think of uninstalling Oracle XE database from the machine and start fresh. This will avoid any conflict going forward.1 person found this helpful