Using power of Oracle Data Pump

If you haven’t used oracle Data Pump and still using old IMP / EXP, it’s time for change. It’s very simple to use and at least 10 times faster (my experience) than IMP/EXP.

Simple steps to configure

1. CREATE OR REPLACE DIRECTORY dump_dir AS ‘{path}’;

2. GRANT READ, WRITE ON DIRECTORY dump_dir TO {user};

3. expdp user/pass directory=dump_dir dumpfile={filename} logfile={logfile} parallel={threads}

4. impdp user/pass directory=dump_dir dumpfile={filename} logfile={filename} parallel={threads}

— For importing to new schema use remap_schema

impdp user/pass remap_schema={orig schema}:{new schema} directory=dump_dir dumpfile={filename} logfile={filename} parallel={threads}

— For importing to new tablespace use remap_tablespace

impdp user/pass remap_schema={orig schema}:{new schema} remap_tablespace={orig tbs}:{new tbs} directory=dump_dir dumpfile={filename} logfile={filename} parallel={threads}

— We can even specify multiple TBS to remap

impdp user/pass remap_schema={orig schema}:{new schema} remap_tablespace={orig tbs}:{new tbs},{orig tbs 1}:{new tbs} directory=dump_dir dumpfile={filename} logfile={filename} parallel={threads}

— Thread value can be decided based on available number of CPU’s.

Advertisements
This entry was posted in Oracle Data Pump and tagged . Bookmark the permalink.

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