Hi,
I have a Spring Boot application with a single connection pool and multiple schemas. I’m trying to have 1 revinfo in each of my Oracle schemas. However, this doesn’t seem to work. Below is what I’ve configured.
Each entity has the schema defined such that they will be created into the respective schemas e.g. @Table(name=“TABLE_1”, schema=“SCHEMA1”), and another is @Table(name=“TABLE_2”, schema=“SCHEMA2”).
When Hibernate generates the tables, it has correctly placed the tables and its audit tables in the correct schema. The issue comes with the REVINFO. For some reason, the REVINFO will be created only in 1 of the schema. This creates a problem whereby tables in other schemas require granting reference to the REVINFO in SCHEMA1.
Is there a way to configure it such that each schema has its own REVINFO, and all tables within each schema references its own REVINFO within the same schema?
Thank you.