title: Loading an Oracle table with an encrypted LOB file and then decrypting it
body: <p>I am being given a large encrypted file containing 10 million rows of data.</p>
  
  <p>I need to load this into an oracle database (in it's encrypted form) and then decrypt it in the database using pl/sql and the oracle built-in dbms_crypto.</p>
  
  <p>I then need to process the unencrypted LOB to seperate out the 10 Million rows.</p>
  
  <p>I will have the public key for the file. The file will be about 5GB in size.
  Is this possible using just pl/sql? (and the oracle built-ins)</p>
  
  <p>Has anyone had any experience of doing this sort of thing? - any pointers will be most welcome.</p>
  
  <p>Thanks </p>