SQL SQL> create directory filedir as '/u01/app/oracle/dbdir'; Directory created. SQL> grant read, write on directory filedir to pbadmin; SQL> create user pbadmin2 identified by mit; User created. SQL> grant create session, resource to pbadmin2; SQL> grant read, write on directory filedir to pbadmin2; SQL> grant create session, resource to pbadmin2; SQL> grant unlimited tablespace to pbadmin2; COMMAND LINE $ expdp pbadmin/mit DUMPFILE=pbadmin.dmp DIRECTORY=filedir SCHEMAS=pbadmin $ impdp pbadmin2/mit dumpfile=pbadmin.dmp directory=filedir remap_schema=pbadmin:pbadmin2