title: Copy data from one database to another in Oracle
body: <p>I have 2 Oracle databases and I frequently copy data from prod DB to test DB using TOAD, by generating insert scripts for Prod DB and running it on the test DB later.</p>
  
  <p>I am trying to do it faster through a batch file.</p>
  
  <p>I think that I can use <a href="https://stackoverflow.com/questions/8944156/how-to-copy-data-from-one-database-table-to-another-database-table">this</a> solution but the DB has an <code>auto-increment</code> column. If I use this solution, would that column be affected? Do I need to change the script in some way? I haven't tried this so far as I have no access do the DB and would be able to test this only on Monday.</p>
  
  <p>Is there a better way I can accomplish this? What I am essentially looking for is doing the whole copy procedure using a batch file, which would minimize the time I spend doing this using TOAD.</p>
  
  <p>Also, it's fine by me if I can be guided in the right direction, if solution is not simple.</p>