Recently Sabrix had some issues and they turned on logging. Sabrix detailed messages go into the CLOB column extended_message present in the table sabrix_log. However we were unable to see beyond 4000 characters of a row in sqlplus. Instead of using any special tools to see the contents of a CLOB column, I advised the DBAs to extract the data like this:
create table sabrix_clob as select extended_message from sabrix_log;
exp file=sabrix_clob.txt userid=apps/apps tables=apps.sabrix_log
Export dump file is an ASCII file if all you are exporting is character data. You can very easily see the contents of the CLOB column inside the export dump file.
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps