Usage of LONG oracle datatype

[isopov]

Oracle LONGs should be avoided as possible:
https://stackoverflow.com/questions/3599211/oracle-long-or-clob
https://stackoverflow.com/questions/13582213/why-oracle-allows-only-one-long-column-per-table
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1460004570029

Comparing that to TEXT type that for Postgres is the most recommended type for storing strings is really misleading. Investigate if it is possible to replace LONG usage with CLOB for Oracle.