The script in the folder /opt/openfire/resources/database/24/openfire_oracle.sql is not correct.
The command to add a column is not correct for Oracle 12, ADD COLUMN must be replaced by ADD.
Best regards,
Daniel
The script in the folder /opt/openfire/resources/database/24/openfire_oracle.sql is not correct.
The command to add a column is not correct for Oracle 12, ADD COLUMN must be replaced by ADD.
Best regards,
Daniel
Thanks, filed as [OF-1280] Wrong ADD COLUMN syntax for Oracle Upgrade Scripts - IgniteRealtime JIRA