title: Reduce the SYS_LOB file in Oracle
body: <p>I have expanded the table space to Oracle, 9 GB in size. But faced with the problem a few months later, the file SYS_LOB0000098796C00006 $$ took 8.5 GB (and 500 MB left for different index tables and so on). I save the photo on the server (via UTL_FILE), not in the table space. What can be done with this file to reduce it ??? I will be grateful for the help).</p>
  <p>I write imafe on server:</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>  V_JSON64   := apex_json.get_clob (p_values =&gt; json_table, p_path =&gt; 'snapshot', p0 =&gt; 3); 
    V_SNAPSHOT := iot_general.clob_base64_to_blob (p_clob =&gt; V_JSON64); 
  
  
   v_date_id := lower(common_functionality.new_uuid);
    v_length  := DBMS_LOB.getlength(V_SNAPSHOT) ;
    v_filename_date :=  v_filename ||  v_date_id ;
    v_file := UTL_FILE.fopen('CDN',v_filename_date , 'wb', 32767);
    WHILE v_index &lt;= v_length LOOP
      v_bytecount := 32767;
      DBMS_LOB.read(V_SNAPSHOT, v_bytecount, v_index, v_tempraw);
      UTL_FILE.put_raw(v_file,v_tempraw);
      UTL_FILE.fflush(v_file);
      v_index := v_index + v_bytecount;
    END LOOP;
    UTL_FILE.fclose(v_file);</code></pre>
  </div>
  </div>
  </p>