CLOB to BLOB data type conversion (Doc ID 2204921.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.5.0.1.0 and later
Information in this document applies to any platform.

Goal

A few customers are using columns, such as f1_attachment.attachment_data  to store data and documents for CC&B. The data type of the column is CLOB (text) and not a BLOB, and all binary files uploaded (mostly pdfs) are converted to Base 64 Strings and then stored as CLOBS. This conversion can create significant bloating, uploading 10 files which total 9.35Mb on the filesystem can consume 26Mb on the database.  The overhead for BOLBs is significantly smaller and would reduce the amount of space consumed on the database.  Is there a way to convert columns from CLOB to BLOB?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms