I am very new to oracle. We got a tablespace issue problem!. We have lot of tables with clob datatype columns. The data in that clob column is not always clob. Sometimes it will be below 4000 and sometimes it is even null. When I searched from user_segments table,it is showing 78.38GB was taken by SYS_LOB0345435203$$.
We have only 96 GB total tablespace. What we are thinkng is whenever we declare some column is clob, irrespective of number of characters it is allotting some predefined space leading us to this problem. Is this correct? If so, how could we solve the issue?