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.