My intention is to import the data of schema 'SCOTT'. I have exported it from db1 using expdp scott/tiger schemas=scott dumpfile=scottexp.dmp ...... Now When I try to import the same in database db2 what would be the syntax. I don't have the SCOTT user in database db2(intentionally deleted to test). I tried with sysdba & system but unsuccessful.
impdp xxxxx schemas=yyyyy dumpfile=scottexp.dmp....
Please let me know the xxxxx and yyyyy values here.
Thanks in advance.