How do I copy or import Oracle schemas between two different databases on different servers?

Question

What is the best way to copy schema from one user/instance/server:

jdbc:oracle:thin:@deeb02:1535:DH, user pov

to another user/instance/server

jdbc:oracle:thin:@123.456.789.123:1523:orcl, user vrs_development

?

Answer 1

Similarly, if you're using Oracle 10g+, you should be able to make this work with Data Pump:

expdp user1/pass1@db1 directory=dp_out schemas=user1 dumpfile=user1.dmp logfile=user1.log

And to import:

impdp user2/pass2@db2 directory=dp_out remap_schema=user1:user2 dumpfile=user1.dmp logfile=user2.log