Planning for Tablespace Recovery when IOTs and Domain Indexes are involved.

Oracle RDBMS 12.1.0.2

I am planning the upgrade of a third-party product that installs into the database.  There is a metadata component from the install, where it keeps track of everything, I have this installed into one tablespace.   There is also a data component, where data are loaded with the client front-end tool, which registers with the product, but that data goes into another tablespace.

I'd like to have a rollback plan in case the upgrade fails.  There are two failure types.  The first, is a failure of in the install.  The recovery for that is a flashback to a guaranteed restore point to before the install.  We're good there.