ORA-959 tablespace does not exist | After Rename Drop Tablespace | Solution | ORA-00959: tablespace '_$deleted$

ORA-959 tablespace does not exist | After Rename Drop Tablespace

ORA-00959: przestrzeń tabel '' nie istnieje

IMP-00017: following statement failed with ORACLE error 959:
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace '_$deleted$24$0' does not exist

Yesterday we faced with quite curious problem. Two of our important tables became unavailable after drop on tablespace - tablespace that was defined in those tables subpartitions. Normally I think the database shoudln't permit to drop this tbs... Only on this enviroment this was possible. Anyway...

We couldn't access those tables/partitions by / select / move / rename / drop / exchange / select (by partition) ... nothing ..

The solution was to create new tablespace and replece his id in dictionary tables, and then remove partitions with problematic tablespace.

ALTER TABLE <> DROP PARTITION <>

Create tablespace

id ( TS# ) from ts$ table .
Replace TS# (id)
in tables

tabpasrt$
tabsubpart$
indpart$
etc...

Questions:
kamil.piorekk@gmail.com

Best Regards
Kamil Piórek