expdp\impdp操作

1、创建direcotry

     select * from dba_directories

     create directory backup as ''

在linux系统下，用expdp\impdp工具进行sys用户的导入导出操作提示： LRM-00108错误 
LRM-00108: invalid positional parameter value 'as'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

 解决办法：

  用转义符

具体如下： expdp \' / as sysdba\'   directory=backup full=y dumpfile=fulldump.dmp logfile=fulldmp.log parallel=2;

impdp \'/ as sysdba\' directory=backup full=y dumpfile=fulldump.dmp logfile=fullimp.log parallel=2 table_exists_action=replace

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8748462/viewspace-762678/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8748462/viewspace-762678/