Oracle DBA Tips and Techniques

By Arjun Raja

EXPORT ( EXPDP ) WITH COMPRESSION OF DUMPS IN 11g

Posted by Arjun Raja on January 21, 2010

Datapump in 11g has a good feature to reduce size of exports and resources used on machines and tapes by compressing the dumps as and when the export happens..

In version 10g, datapump did not have the compress option for data – only the default option to compress METADATA only.

Example in 10g –

TEST schema using datapump –

nohup expdp system/xxxxxx schemas=test directory=data_pump_dir dumpfile=test.dmp logfile=test.log &

Export took 2 hours 10 minutes.

Export dump size was 91 gb.

The same data was exported in 11g –

Only difference was adding the following bit to the expdp command in 11g – > compression=all

nohup expdp system/xxxx compression=all schemas=test
directory=data_pump_dir dumpfile=test.dmp logfile=test.log &

Export took 1 hour 15 minutes.

Export dump size – 13 gb

In 11g it took just over half the time and saved 7 times the space which will tremendously reduce the amount of data moved off to tape on a daily basis especially in some databases where exports are taken daily and moved to tape.

Also there is no need to use unix pipes or uncompress dumps before commencing the import as Oracle takes care of that.

Advertisements

2 Responses to “EXPORT ( EXPDP ) WITH COMPRESSION OF DUMPS IN 11g”

  1. radhakrishna said

    hi

  2. I’ve been browsing online more than 4 hours today, yet I never found any interesting article like yours.

    It’s pretty worth enough for me. In my view, if all site owners and bloggers made good content as you did,
    the internet will be much more useful than ever before.

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: