8,仅导出特定对象类型procedure
expdp scott/system@orcl dumpfile=dir_scott:expdp_20121121_scott_procedure.dmp logfile=dir_scott:expdp_20121121_scott_procedure.log schemas=scott include=procedure
expdp scott/system@orcl dumpfile=dir_scott:expdp_20121121_scott_procedure.dmp logfile=dir_scott:expdp_20121121_scott_procedure.log schemas=scott include=procedure
--导入到新建用户user_procedure
impdp user_procedure/system@orcl remap_schema=scott:user_procedure dumpfile=dir_scott:expdp_20121121_scott_procedure.dmp logfile=dir_scott:expdp_20121121_scott_procedure_imp.log schemas=scott
impdp user_procedure/system@orcl remap_schema=scott:user_procedure dumpfile=dir_scott:expdp_20121121_scott_procedure.dmp logfile=dir_scott:expdp_20121121_scott_procedure_imp.log schemas=scott
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-749684/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-749684/