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]

Hello Albert,

The short answer is no you cannot move an object from one datafile to another. For what you are wanting to achieve you would have to:

1. Identify the objects in the datafile you want to reclaim.

2. Create a new tablespace (eg: PSAPSR3TMP)

3. Reorg the objects to the new tablespace

4. Perform the same check from step #1 to ensure that there are no objects left in the datafile.

5. Drop the datafile.

6. Reorg objects from step #3 back to PSAPSR3.

That's just a very high level overview of what you would have to do.

KR,

Amerjit