RE: Data Pump schema mode import

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Mon, 10 Aug 2009 13:14:16 -0500
Message-ID: <565F609E6D736D439837F1A1A797F341020CCB09_at_ADMINMAIL1.ui.uillinois.edu>

Would be helpful to include the export commands used.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com
Sent: Monday, August 10, 2009 1:11 PM
To: wellmetus_at_gmail.com
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: Data Pump schema mode import  

I thought it worked just like imp, unless its a full and the create user commands are embedded in the "dmp" file then the user has to be precreated? It's monday so I could be way off base :)

joe

---

Joe Testa, Oracle Certified Professional (Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage? Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.

From:

Roger Xu <wellmetus_at_gmail.com>

To:

oracle-l_at_freelists.org

Date:

08/10/2009 02:09 PM

Subject:

Data Pump schema mode import

Sent by:

oracle-l-bounce_at_freelists.org  

---

Dear list,   

It's my understanding that the schema will be created if it does not exist before a data pump import.
If that is true, why the impdp command below failed and I had to create the schema for it to work?   

Thanks,   

Roger Xu   

$ impdp system/xxxxxx SCHEMAS=TSDBA \
> directory=pump_dir dumpfile=tsdbaups60d0pump.dmp \
> logfile=tsdbaups60d0pump.imp

Import: Release 10.2.0.4.0 - 64bit Production on Monday, 10 August, 2009 10:03:32

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** SCHEMAS=TSDBA directory=pump_dir dumpfile=tsdbaups60d0pump.dmp logfile=tsdbaup s60d0pump.imp
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA ORA-39083: Object type PROCACT_SCHEMA failed to create with error: ORA-31625: Schema TSDBA is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV ','CURRENT_SCHEMA'), export_db_name=>'UPS60D0', inst_scn=>'830183 1157951');COMMIT; END;   

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 10 2009 - 13:14:16 CDT