C:\Documents and Settings\Administrator>IMPDP TEST/TEST DIRECTORY=DMPDIR DUMPFILE=SCOTT.DMP

Import: Release 10.1.0.2.0 - Production on Friday, 02 January, 2009 15:30

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "TEST"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TEST"."SYS_IMPORT_FULL_01":  TEST/******** DIRECTORY=DMPDIR DUMPFILE=S
COTT.DMP
Processing object type SCHEMA_EXPORT/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: error changing username from TEST to SCOTT
ORA-01031: insufficient privileges
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>'SCOTT', export_db_name=>'OR
CL', inst_scn=>'339736');COMMIT; END;


Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-31684: Object type TABLE:"SCOTT"."DEPT" already exists
ORA-31684: Object type TABLE:"SCOTT"."EMP" already exists
ORA-31684: Object type TABLE:"SCOTT"."BONUS" already exists
ORA-31684: Object type TABLE:"SCOTT"."SALGRADE" already exists
ORA-39138: Insufficient privileges to load data not in your schema
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39111: Dependent object type INDEX:"SCOTT"."PK_DEPT" skipped, base object ty
pe TABLE:"SCOTT"."DEPT" already exists
ORA-39111: Dependent object type INDEX:"SCOTT"."PK_EMP" skipped, base object typ
e TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39111: Dependent object type CONSTRAINT:"SCOTT"."PK_DEPT" skipped, base obje
ct type TABLE:"SCOTT"."DEPT" already exists
ORA-39111: Dependent object type CONSTRAINT:"SCOTT"."PK_EMP" skipped, base objec
t type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39111: Dependent object type REF_CONSTRAINT:"SCOTT"."FK_DEPTNO" skipped, bas
e object type TABLE:"SCOTT"."EMP" already exists
Job "TEST"."SYS_IMPORT_FULL_01" completed with 11 error(s) at 15:30