Question: how to transfer data from one database to another database in oracle?
Answer: On the tool bar, select Tools>Database copy.
Identify source and destination connections with the copy options you would like.
For object type, select table(s).
Specify the specific table(s) (e.g. table1).