The reason for this exception is that each one files inside the Procedure tablespace has to be on-line to ensure that Oracle to operate appropriately. For the same rationale, the datafiles of a tablespace that contains active rollback segments have to remain on the net. The fallout from data loss