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

Question

What is the best way to copy a schema from a single 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 are using Oracle 10g +, you should do this work with Data Pump:

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

And for import:

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

Answer 2

Use oracle exp utility to get schema dump from the first database

 exp user1/ pass1@db1 owner=user1 file=user1.dmp log=user1.log 

Then use the imp utility to populate another schema in another datbase

 imp user2/ pass2@db2 fromuser=user1 touser=user2 file=user1.dmp log=user2.log