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.
Toad will show a failure or success message.
Job done!