Cannot drop user
505417Oct 5 2007 — edited Oct 5 2007Hi,
Somebody inadvertently deleted two datafiles from our test database. I took those files offline and the instance of the database could start. A user who has objects in those datafiles is now useless and I want to drop it. Unfortunately I cannot do that due to the following error:
sys> drop user STRMUSER cascade;
drop user STRMUSER cascade
*
ERROR at line 1:
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7: '/home/oracle/tim/streams_tbs.dbf'
I don't also need the tablespace but I cannot delete it because of the following:
sys> drop tablespace STREAMS_TBS including contents and datafiles;
drop tablespace STREAMS_TBS including contents and datafiles
*
ERROR at line 1:
ORA-22868: table with LOBs contains segments in different tablespaces
How can I drop the mentioned items? Any help will be appreciated.
Regards,
Tim