how to copy all tables from one database to another one using oracle sql

Question

I have two oracle connections and want to transfer the data/tables for a particular operational database from connection1(source) to connection2 (target). How would I do this?

Answer 1

Backup one database either using:

• exp/imp (these are legacy utilities and you should probably use more modern ones);
• expdp/impdp; or
• rman

Then restore it on the other database.

Answer 2

Usually, we do that by Data Pump Export/Import utilities, they are designed for such a purpose (moving data around). Here's documentation; I suggest you read it.