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;