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

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 

Other related posts: