Re: Data Pump schema mode import
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: wellmetus@xxxxxxxxx
- Date: Tue, 11 Aug 2009 08:39:55 +1000
It should create the user
I use following procedure regularly.
Directory is not specified as I use the default directory.
expdp system/********* dumpfile=expdp_objpm_6384.dmp
logfile=expdp_objpm_6384.log schemas=objpm
and to import in new instance I drop user objpm
impdp system/**********dumpfile=expdp_objpm_6384.dmp
LOGFILE=impdp_objpm_6384.log remap_tablespace=TS1:TS2
Jack
2009/8/11 Roger Xu <wellmetus@xxxxxxxxx>
> 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;
>
>
>
--
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
Other related posts:
