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!