Partitioned table fails with ORA-00959: Tablespace '_$deleted Does Not Exist error

Prolbem:

ORA-00959: tablespace '_$deleted11$' does not exist.

and Check Partition DDL store is '_$deleted11$'

Solution:

Updating the store in clause to new tablespace resolves the issue.

SQL> alter table <table name> set store in (<new tablespace name>);

參考來源：

Insert on partitioned table fails with ORA-00959: Tablespace '_$deleted Does Not Exist error (Doc ID 2632422.1)