Exporting a CLOB

myoracledbablog

I’m in the final phase of a clear down process to remove data that is no longer legally required from a production database. Unfortunately for me this involves writing the data directly to disc in csv format for reference later, not my preferred option for this piece of work but it pays the bills – so who am I to complain? Anyway the process has been relatively painless up to now – I’m hitting tables with clobs and large ones at that – ranging from 10,000 characters up to just over a 1,000,000 in length. How the devil do I write these to a CSV?

From the start of this piece of work the best method appeared to be to export the data in a format file that would make it easy to use as reference via an external table due to a potential requirement to have to audit from…

View original post 1,331 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s