Oracle Database Import

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 EXPIMP AS ‘{path}’;

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

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

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

— For importing to new schema use remap_schema
impdp user/pass remap_schema={orig schema}:{new schema} directory=EXPIMP 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=EXPIMP dumpfile={filename} logfile={filename} parallel={threads}

— We can even specify multiple TBS (tablespace )  to remap
impdp user/pass remap_schema={orig schema}:{new schema} remap_tablespace={orig tbs}:{new tbs},{orig tbs 1}:{new tbs} directory=EXPIMP dumpfile={filename} logfile={filename} parallel={threads}

Hits: 30

Leave a Reply

Your email address will not be published. Required fields are marked *