RE: Datadump import questin

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <JDunn@xxxxxxxxx>, "oracle-l digest users" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Apr 2010 09:11:39 -0400

    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.



Other related posts: