Oracle Database Discussions

Hi All,

I am trying to import the schema from 11gR1 version to 11gR2 database.

Schema : dan
Tablespace : multi

I took the export of dan schema using expdp which is succeefully done.

when i try to import the into target db

Processing object type SCHEMA_EXPORT/USER
ORA-39083: Object type USER failed to create with error:
ORA-00959: tablespace 'MULTIACCESS_DATA' does not exist
Failing sql is:
CREATE USER "DAN" IDENTIFIED BY VALUES 'S:2814BF86EF3DD922F9BBE119CF9A84886BB25A6641AA63280A3BF992634D;0C1527BEB47B289D' DEFAULT TABLESPACE "MULTI" TEMPORARY TABLESPACE "TEMP"

The tablespace is not present in target db. I know that if schem is not present that in target db that will be created by impdm i dont know about tablespace.

impdp directory=EXPORT_DIR2 dumpfile=1007472_exp.dmp logfile=1007472_imp.log remap_schema=dan:dan remap_tablespace=MULTI:MULTI

My concern is will remap_tablespace will create the tablespace in target db . In my case multi which is not present in target db.


Multi the the default tablespace of source schema which is not present in target schema.

Os version is RHEL 5

Please help.

Thanks in advance.