When you deploy Confluence 1.4.1 on Oracle 8.1.7 database and try to change page title you get Oracle error message:
ORA-00933: SQL command not properly ended

The problem is that the following files have hardcoded SQL92 style "INNER JOIN" which is not supported by Oracle 8i:
confluence\WEB-INF\classes\com\atlassian\confluence\core\ContentEntityObject.hbm.xml
confluence\WEB-INF\classes\com\atlassian\confluence\links\persistence\dao\hibernate\HibernateLinkDao$2.class
confluence\WEB-INF\classes\com\atlassian\confluence\links\persistence\dao\hibernate\HibernateLinkDao$3.class
confluence\WEB-INF\classes\com\atlassian\confluence\pages\persistence\dao\hibernate\HibernatePageDao$2.class

I rewrote these SQL statements in these files without INNER JOIN syntax and after that everything works fine.
Modified files are included in attachment.

It would be good not to use hardcoded INNER JOIN statements as it limits functionality of Confluence on older database versions. All dynamically created SQLs that are generated by Hibarnate are OK for Oracle 8i.