Can't drop tablespace (ORA_14405)
lesakFeb 11 2009 — edited Feb 11 2009Hi,
Unfortunatelly I droped 4 files from tablespace. It wasn't very important but I can't drop whole tablespace from database.
First I execute this commad:
alter database datafalie '/oradata/tablespace_part01.dbf' offline drop;
alter database datafalie '/oradata/tablespace_part02.dbf' offline drop;
alter database datafalie '/oradata/tablespace_part03.dbf' offline drop;
alter database datafalie '/oradata/tablespace_part04.dbf' offline drop;
and after that I execute:
drop tablespace TABLESPACE_NAME including contents cascade constraints;
but there I have error ORA-14405 !!
Please help - how I can drop this tablespace from database!!??
Best.