Thursday 2 May 2013

Database import from higher version11g to lower version10g in oracle

Database import from higher version11g to lower version10g in oracle:

 $expdp manjit/manjit directory=marketing_dp dumpfile=marketing.dmp logfile=marketing.log schemas=marketing version=10.2

 this is for verson=10.2 to import to macosx10g

 On target os:


SQL> create or replace directory marketing_dp as '/home/oracle';

Directory created.

SQL> select directory_name from all_directories;

SQL> grant read,write on directory marketing_dp to manjit;

 impdp manjit/manjit directory=marketing dumpfile=marketing.dmp logfile=marketing.log REMAP_SCHEMA=marketing:ra

remap, marketing schema is source os  ra schema is target os

No comments:

Post a Comment