title: Is there a way to copy BLOB records between databases in Oracle 10g?
body: <p>We have a production table that has millions of rows in it and contains a BLOB field, I would like to copy a smaller selection of these records into our development database without getting a DBA involved if possible.  I tried the following COPY command but received a <code>CPY-0012: Datatype cannot be copied</code></p>
  
  <pre><code>COPY FROM user/password@prod_db TO user/password@dev_db -
  INSERT TABLE_A (COL1, COL2, COL3, BLOB_COL) USING -
  SELECT COL1, COL2, COL3, BLOB_COL -
  FROM TABLE_A WHERE COL1='KEY' 
  </code></pre>
  
  <p>Is there a way to copy records with a BLOB field between databases via SQL?</p>