Import one schema into another new schema - Oracle

Question

I have a data dmp file exported from one schema user1 using the exp commandline utility   I want to import this dump onto another newly created  empty  schema user 2 using the imp  commandline utility   I tried a few things like   imp system password tesdb fromuser user1 touser user2 file E  Data user1 dmp log E  Data user1 log   I get an error   IMP-00002  failed to open user1 dmp for read Import file  EXPDAT DMP  gt    Any help appreciated

User · Answer

After you correct the possible dmp file problem, this is a way to ensure that the schema is remapped and imported appropriately. This will also ensure that the tablespace will change also, if needed:

impdp system/<password> SCHEMAS=user1 remap_schema=user1:user2 \
            remap_tablespace=user1:user2 directory=EXPORTDIR \
            dumpfile=user1.dmp logfile=E:\Data\user1.log

EXPORTDIR must be defined in oracle as a directory as the system user

create or replace directory EXPORTDIR as 'E:\Data';
grant read, write on directory EXPORTDIR to user2;

User · Answer

The issue was with the dmp file itself  I had to re-export the file and the command works fine  Thank you  Justin Cave

[oracle] Import one schema into another new schema - Oracle

Examples related to oracle