1

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.

  • Yes. But I don't want to explicitly create the user and import but the command itself should create the user. I want the same user 'scott'. – Newbie-oracle Mar 12 '15 at 13:00
  • You need to perform the export and imports as a system user. Then it should automatically create the user when importing. You need the permissions when exporting in order to be able to extract the password information etc and when importing in order to be able to create the user. – Colin 't Hart Mar 12 '15 at 13:08
1

impdp SCOTT/password directory=DUMPDIR dumpfile=fromuser.dmp logfile=impdp.log remap_schema=SCOTT:DEV_LOCAL FULL=YES

DEV_LOCAL will be the local empty schema that you should create!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.