Move data from one oracle db to another db using toad

I am new to oracle and this might be a simple question for many.

I need to take data from one db and insert it into other db. The databases are on the same version and edition. I am currently using Toad.

All I have been able to find out is to use export and import utilities, which I am not able to execute from my toad client. I'm hoping for a query to retrieve data in a file and then import this file into another database.

If you have Toad I assume you can connect to both databases from it.

• Select the origin table in the schema browser in Toad, right click, select "Create in another schema" or "Copy Data to another schems".

• A dialog box appears, select your options as required.

• then a "Destination" dialog box appears. Select the connection to the destination database and schema of your choice

• Click on execute.

Toad will show a failure or success message.

Job done!

StackExchange Database Administrators Q#18408, answer score: 6