John, How was the dump file created? If it was done in user mode then it will not have the schema information so that impdp can recreate the schema. It has to be done in schema mode from a dba account. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn Sent: Tuesday, April 06, 2010 9:07 AM To: oracle-l digest users Subject: Datadump import questin How do I get datapump to create the schema before objects are imported. My syntax is impdp system/system1pw schemas=myschema directory=dump_dir dumpfile=myschema.dmp logfile=dpimport.log I get errors about the user myschema not existing. John