I deleted datafiles with asmcmd. I need to delete tablespace and tables on this tablespace. I tried:
drop tablespace tablespace_name including contains cascade constraints
ORA-14405: partitioned index contains partitions in a different tablespace
When I tried drop table, index or partition, getting this event and do nothing.
optimizer stats update retry.
How can I drop tablespace and all tables on this tablespace easily?