Oracle impdp (import data pump) Posted on August 14, 2012 by torrancejones 1). Create a directory: 2). Copy your database to the directory C:\ 3). Issue the impdp command impdp user/secret@ORACLE11G schemas=USERSCHEMA directory=export_dir dumpfile=export.dmp logfile=output.log