HI,
We have done heavy reorg on PSAPBIS table and move out losts of object to different tablespaces to seperate the business area for growth monitoring.
Now our PSAPBIS is left with lots of gaps and we cannot claim that space. The size is 4TB but it has only 1TB of data, rest of empty. Shrink is not praticle.
Is it possible to that we drop the PSAPBIS and move the objects to new one like PSAPBIS1 and then recreate PSAPBIS then move it back.
What is the best pratice. Is it absolute necessary to have PSAPBIS.
I need a expert advice please.
Your help will be greately appreciated.
Regards,
SC