title: Copying transaction table data of from production environment to development in Oracle
body: <p>I want to copy the transaction table data from production environment to development environment in Oracle 11i. </p>
  
  <p>Currently, we are manually copying the data from production environment to development environment using "copy data to another schema" option in Toad. But, I want this to be done by programmatically or some options where in I need to specify the list of tables names to be copied, source environment and destination environment. Once I specified all the required details, it has to copy the data from production environment to development environment.If I do this I can avoid manual mistakes.</p>
  
  <p>Please suggest the various option to accomplish the above task. </p>
  
  <p><strong>Note:</strong> I'm a beginner in Oracle as well as in Toad.</p>