Relocation data from one data file to another datafile

[#1]

Dear all,

I will perform big clean up of SAP system. And after reorganization i will need to remain only 2-3 datafiles of PSAPSR3 tablespace. I know that i can`t to drop not empty datafile. How to relocate data from not empty datafile to another, where space is enough?

BR, Albert

[Former Member]

Hi Albert,

How are you going to perform cleanup/reorganization? I believe you can achieve this directly within reorg process (Creation of new tablespace). Please check below SAP Note to check reorg processes with different options.

646681 - Reorganization of tables with BRSPACE

Thanks,

Manish