reorg RH on Oracle without a downtime?

Discussion created by Carsten_Schmitz on Sep 20, 2018
Latest reply on Oct 4, 2018 by Biesandr

Our RH on Oracle is 12 million records and rather fragmented.


Does anyone know of a way to defragement (aka reorg, aka compact) the RH table on a production system without requiring a downtime? RH is linked with a primary key to RT, which has 221 million records, because every line of every database-homed report is a single record in RT (perculiar design decision, this ...). Our DBA tells me he can't compact RH in online mode. It takes three hours, then fails because it can not get a lock on RT.


Later, we will need to compact/reorg RT also, which we suspect will run into the same sort of issues, just with many more hours before failing.