Home > Oracle Apps, Oracle Database > Space reclaim using complete database export import

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.

before_and_after

Hope this helps. Happy learning!!!

-Anand M

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: