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,

Information provide by folks in replied are very helpful, go through the note.

In case you have LONG and LONG RAW columns in the tables system/oracle  need outage mean Oracle need to be offline unless you change LONG and LONG RAW to LOBs or CLOBs before hand.

Another point , you need a good amount space on Archive log, As sometimes backup process slower than Oracle created offline redo log file or turn off Archive log in case system is non-prod.

Good luck.

Thanks,

Hardeep