Dropped a datafile now I cant drop the tablespace
Yesterday I accidently deleted a datafile (rm -rf) from the OS. I have no recovery options. Undo delete, restore from backup, rman, all failed. I need to drop the tablespace in the DB so I can recreate it, but I get ORA-29857 Domain Indexes and Secondary Objects exists in Tablespace.
I'm on Oracle 19.25 in a Linux environment. Single DB no RAC, no ASM.
I just need to drop the tablespace and all contents.
JWR