Non-existent Blueprint AO Tables are Not Automatically Recreated in Oracle DB

Summary

The following Blueprint AO tables are not automatically recreated on Confluence startup should they not exist in the DB. As they are AO tables, they should have been recreated automatically when not existed on the DB itself on Confluence startup.

• AO_54C900_CONTENT_BLUEPRINT_AO
• AO_54C900_C_TEMPLATE_REF
• AO_54C900_SPACE_BLUEPRINT_AO

This issue occurs for Oracle DB.

Environment

• Database: Oracle (11g)

Steps to Reproduce

1. Stop Confluence
2. Drop the following Blueprint AO tables on your Oracle Confluence DB:
   • AO_54C900_CONTENT_BLUEPRINT_AO
   • AO_54C900_C_TEMPLATE_REF
   • AO_54C900_SPACE_BLUEPRINT_AO
3. Start Confluence.

Expected Results

Should there be no Blueprint AO tables exist in the DB, Confluence will then recreate those tables accordingly on Confluence restart.

Actual Results

The mentioned Blueprint AO tables are not recreated after Confluence restart.

Notes

This bug does not occur in PostgreSQL DB.