The stream has been disabled-the partitions of these indexes are unavailable.

Today, I used hibernate to access the oracle database and found a problem;
Java code
<Span style = "font-size: small;"> icacert IcaCaCert = icaCaCert. findByCertSerialNumber (certSerial); </span>
 
An exception is reported: the stream is disabled.

Looking at the database, we found that there is a LONG text field of the type: LONG (oracle-specific type, equivalent to mysql longtext)

So I will change this type to ask about the clob type (irreversible)
SQL code
<Span style = "font-size: small;"> alter table ICA_CA_CERT modify SIGN_BUF_P7 clob; </span>
When you try again, there is no stream closed exception, but a new exception occurs: partitions of indexes such as ITRUSCA. ICA_CA_CERT_USER_ID_IND are unavailable.

The original table has an index. After I change the type, the index is incorrect;

Re-indexing to solve the problem;

SQL code
<Span style = "font-size: small;"> alter index ITRUSCA. ICA_CA_CERT_USER_ID_IND rebuild online; </span>