Move data from one oracle db to another db using toad

oracle

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.

Best Answer

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!

Related Question