Reclamation and materialized views

The GROOM TABLE command is used to reclaim records or blocks from a table, and applies only to base tables, not to SPM views.

Note: Since the use of GROOM TABLE on a base table returns an error if there are any active materialized views on the table, these views must be suspended before you run the command.