请问一个数据导入的命令应该如何写的问题?impdp
shiter 人工智能领域优质创作者 博客专家认证 2018-03-27 03:06:15
##导出命令
expdp hctpa/hctpa2015 FULL=y DUMPFILE=dpump_dir1:full1%U.dmp, dpump_dir2:full2%U.dmp
FILESIZE=2G PARALLEL=3 LOGFILE=dpump_dir1:expfull.log JOB_NAME=Yiyong_datadump_4_insightzen
tablespace
以下这样写有问题么
##
impdp c##yiliao/yiliao@orcl full=y directory=dir_yiliao dumpfile=full1%U.dmp remap_schema=hctpa:c##yiliao exclude=GRANT remap_tablespace='(tempts1:yiliao,TBL:yiliao,log:yiliao,wrk:yiliao)' tablespaces=tempts1,TBL, log,wrk