Hi ALL GURUS
I am using datapump utility (10g R2) to import database from Database A to Database B .While importing datapump export file I am getting following error. Is any body has any idea to avoid these error. One option is to create a same Tablespace as source Database A in target database i.e Database B .
Import syntax.
C:> IMPDP system/********@ora1 SCHEMAS=COL1 REMAP_SCHEMA=COL1:COL2 DIRECTORY=DBPUMP_DIR1 DUMPFILE=DUMP_ONLY_SCHEMA_COL1.DMP LOGFILE=DUMP_ONLY_SCHEMA_COL1.log
Note umpfile DUMP_ONLY_SCHEMA_COL1.DMP has been manually copied to Directory (DBPUMP_DIR1) on target database B.
Error:
Failing sql is:
CREATE TABLE "COL2."."ABC" ("ACCT" VARCHAR2(15) NOT NULL ENABLE, "BUS" VARCHAR2(5) NOT NULL ENABLE, "RECORD" VARCHAR2(2), "ACCO" VARCHAR2(40), "ACCTC” VARCHAR2(40), "CO
ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'MA_TEST' does not exist
However when we use original exp/imp we need not to create tablespaces just do fromuser touser is fine.
Any clue to avoid above error in expdp/impdp.

Regards