Mind twister for me, as I never thought about this procedure for system tablespace.
There is Enterprose Manager REORG utility, one can try what it does is move all the current objects into a temp tablespaces and then put back to the tablespace with the newly defined storage clause.




Reply With Quote