Hi,
I have exp dump of a schema. how to import the dump into another schema using imp.
exp command used: exp abc/abc file=abc.dmp owner=abc log=abc.log; (default tablespace: abcdata and abcindex)
I tried the imp to import the abc schema into abcclone schema
imp abcclone/abcclone file=abc.dmp fromuser=abc touser=abclone log=abcclone.log (default tablespace of abcclone schema: abcclonedata and abccloneindex)
I face the error like
"CREATE TABLE "E_C005" ("RECID" VARCHAR2(255 CHAR), "XMLRECORD" BLOB) "
" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELI"
"STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "ABCDATA" LOG"
"GING NOCOMPRESS LOB ("XMLRECORD") STORE AS "LOB_FGBB_RE_C005" (TABLESPACE "
""ABCDATA" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 CACHE STORA"
"GE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'ABCDATA' does not exist
IMP-00017: following statement failed with ORACLE error 959:
What is the datapump remap_schema, remap_tablespace equivalent in normal imp?
Thanks
KSG