#mkdir -p /data/expdp

#chown -R oracle.oinstall /data/expdp

#chmod 775 /data/expdp

#su - oracle

$sqlplus / as sysdba

SQL> create or replace directory expdp as '/data/expdp';

Directory created.

SQL> grant read, write on directory expdp to gddx;

Grant succeeded.

$expdp gddx/gddx directory=expdp_dir dumpfile=test.dmp logfile=test.log schemas=gddx;

在导入之前不要手动创建要导入的用户如：gddx,但是与gddx用户相关的表空间要创建如：WEBTRACE3_DEMO WEBTRACE3_GDDX

$impdp system/yysoft601 DIRECTORY=dir_expdp DUMPFILE=test.dmp logfile=imptest2010.09.01.log TABLE_EXISTS_ACTION=SKIP SCHEMAS=gddx;

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

解决方法

mount -t nfs 192.168.1.220:/data/expdp -o hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3 /lxp

ITPub博客

关于expdp/impdp的迁移