Space reclaim using complete database export import
We had a non-prod database which was having more than 50% of space as free. Objective was to reclaim the space at OS level and release the space back to storage.
This is an Oracle E-Biz environment.
Ebiz Version – 12.2.2
Oracle DB version – 11.2.0.3
OS – 64 bit Oracle Linux
Tried to resize the datafile as much as possible but could not reclaim enough space. Hence thought of doing the full database re-org using export and import.
This document demonstrates step by step procedure with screenshots to do full database reorg using export/import
Full Database reorg using export-import
Post export/import, I was able to reclaim around 4 TB (65% reduction) of space.
Pls see the result below.
Hope this helps. Happy learning!!!
-Anand M
Categories: Oracle Apps, Oracle Database
E-biz, export/import, Reorg
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Oracle Application Technology 