At any rate, as long as you are able to perform queries using SQLPLUS, it should be fine. The schema has already had to be modified specifically to handle Oracle restrictions that get applied to column types. As we don't ever select specific values from the LONG BINARY column, it is probably just the Oracle web client doing a DISTINCT or something. Try SQLPLUS with
SQL> select distinct ( serializable_value) from node_properties; select distinct ( serializable_value) from node_properties * ERROR at line 1: ORA-00997: illegal use of LONG datatype
Archive: Alfresco Content Services / ECM
Archive content from 2016 and relating to earlier versions of Alfresco Content Services, Community and Alfresco One.