Question: how to copy data from one database to another in toad?
Answer: 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. ... 
Click on execute.