title: How to export table that has an encrypted column
body: <p>I have a table that has a column (lets call it amount). When we insert data to this table, we make use of a trigger to encrypt the data in the amount column using dbms_obfuscation_toolkit.DES3Encrypt. </p>
  
  <p>When I export the table to a dmp file and import it in another schema, some data in this column appears to be truncated and cannot be decrypted. </p>
  
  <p>While attempting to decrypt this column the following is the error i get</p>
  
  <pre><code>ERROR at line 1:
  ORA-28232: invalid input length for obfuscation toolkit
  ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 84
  ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 255
  ORA-06512: at "USER.DECRYPT3DES", line 9
  </code></pre>
  
  <p>I used the "exp" command to export the table. Is there any other means of exporting the table to a dump file? </p>
  
  <p>Thanks</p>