RE: Data Pump schema mode import
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: cjnewman@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 Aug 2009 14:37:06 -0700 (PDT)
you need to use the remap_schema parameter
remap_schema=fromuser:touser
K
--- On Mon, 8/10/09, Newman, Christopher <cjnewman@xxxxxxxxxxxxx> wrote:
From: Newman, Christopher <cjnewman@xxxxxxxxxxxxx>
Subject: RE: Data Pump schema mode import
To: TESTAJ3@xxxxxxxxxxxxxx, wellmetus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx, oracle-l-bounce@xxxxxxxxxxxxx
Date: Monday, August 10, 2009, 1:14 PM
Would be helpful to include the export commands used.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of TESTAJ3@xxxxxxxxxxxxxx
Sent: Monday, August 10, 2009 1:11 PM
To: wellmetus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
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@xxxxxxxxx>
To:
oracle-l@xxxxxxxxxxxxx
Date:
08/10/2009 02:09 PM
Subject:
Data Pump schema mode import
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
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;
Other related posts:
