Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center