title: Create a Test Database copy of Production with only a sample set of Data
body: <p>We have 2 Oracle databases.  One is our Production customer database.  The other is a test database.  The Test database is a copy of production without any data...just empty tables.  I am trying to come up with an efficient and effective way to copy a sample set of data from the Production db to the Test.</p>
  
  <p>I need to start with a sample list of PKs from our Customer table and write a process to populate the test database Customer table with that sample.  Then, I need to populate child tables with relevant data based on the sample.</p>
  
  <p>We used to have a Java process that would use a prepared statement to select data from Production...build a file based on the result set...then use an update statement to get it into the Test db.  It was horribly inefficient.  </p>
  
  <p>I am not a DBA so I don't know much of that realm.  I tried to Google some info about Database Links but couldn't find very good examples.  </p>
  
  <p>Does anyone know of a way to do this...or, at least give me a starting point?</p>