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
$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