CLOB to BLOB data type conversion
Last updated on MAY 01, 2018
Applies to:Oracle Utilities Customer Care and Billing - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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?
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