Aga 发表于 2013-1-28 19:28:31

impdp

job_name=impdp_eccok_dz_fulldirectory=work_exports_eccok_dzdumpfile=expdp_eccok_dz_full_%u.dmplogfile=impdp_eccok_dz_full.logcontent=ALLTRANSFORM=storage:nremap_schema=eccok_dz:local_eccok_dzremap_tablespace=ECCOK_DZ:users
1) Create a schema
2) Create or replace directory dir_name as ‘os_dir’
3) Modify the par file
a) remap_schema=eccok_dz:local_eccok_dz
b) remap_tablespace=ECCOK_DZ:users
4) D:\dump>impdp system/system parfile=impdp_eccok_dz_full.par
页: [1]
查看完整版本: impdp