I have used below command for import --------------------
impdp Cxxx/Cxxx@QA DUMPFILE=exp16072015.dmp remap_schema=QA:Cxxx remap_tablespace=(E_A_DATA:C_A_DATA,E_A_INDEX:C_A_INDEX,E_C_DATA:C_C_DATA,E_C_INDEX:C_C_INDEX) log="C.log" table_exists_action=replace
and the output is ------------------
Import: Release 11.2.0.3.0 - Production on Mon Aug 17 14:48:22 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "log=C.log" Location: Command Line, Replaced with: "logfile=C.log"
Master table "CXXX"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "CXXX"."SYS_IMPORT_FULL_01": Cxxx/********@QA DUMPFILE=exp16072015.dmp remap_schema=QA:Cxxx remap_tablespace=(E_A_DATA:C_A_DATA,E_A_INDEX:C_A_INDEX,E_C_DATA:C_C_DATA,E_C_INDEX:C_C_INDEX) log="C.log" table_exists_action=replace
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"CXXX" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "CXXX"."*******" 6.240 GB 74618276 rows
. . imported "CXXX"."*******" 609.4 MB 5450336 rows
. . imported "CXXX"."*******" 449.1 MB 2550070 rows
. . imported "CXXX"."*******" 415.5 MB 14854883 rows
. . imported "CXXX"."*******" 383.2 MB 4583541 rows
. . imported "CXXX"."*******" 107.3 MB 955403 rows
. . imported "CXXX"."*******" 88.33 MB 5609794 rows
. . imported "CXXX"."*******" 11.53 MB 1289 rows
. . imported "CXXX"."*******" 54.86 MB 1383978 rows
. . imported "CXXX"."*******" 47.96 MB 2340074 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "CXXX"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 15:04:08
Here at the end it is showing "SYS_IMPORT_FULL_01" completed with 1 error ...... What is this error? How to resolve this?
Thank You for Your Answer......